Questions tagged as 'sql'

Tagged questions
1
answer

Format dates in sql

I have a program in the c # (Visual Studio) registry that contains a textbox to receive a date. Knowing that SQL writes the date in American format, how can I make the user type the date in Brazilian format and that date can be saved successfull...
asked by 21.07.2016 / 13:57
1
answer

Select next line field

I need to make an appointment by bringing the second value of a field to the first row. That is, I need the value of the first field in the "Time1" column to be filled with the value of the second field in the "Time" column. I created an empty f...
asked by 17.05.2016 / 01:23
0
answers

Groupby doing query gets too slow

Good afternoon people, I'm doing a query in the bank where everything happens well, however when I make use of "groupby" this query gets very slow, very slow even, example, just take the groupby line that the query returns me in less than 1 seco...
asked by 04.08.2016 / 22:01
1
answer

Creating a method "checks" on a DAO class

I have a question when creating a method that checks if a record already exists in my database. In my database I have two tables: User table: (id, login, password); Table Orders: (id, qtd, status, userid); I would like to check the stat...
asked by 24.05.2016 / 22:41
0
answers

Query using Firebird's SUBSTR with linq, queryOver, Criteria

Well, I need to create a query using the firebird "SUBSTR" function with linq, queryOver, or Criteria. I have option to create with HQL or SQL, but these would be my last options. Does anyone have an idea? Here is an example of the query. S...
asked by 10.05.2016 / 19:33
0
answers

changes in linked tables (CASCADE etc ...)

I am learning MYSQL on my own because of the teaching restriction there is in my city and its vicinity, so I would like information on how to use CASCADE in the table I have with this structure: tblUser idu int not null auto_increment pk name...
asked by 27.05.2016 / 02:01
1
answer

Login Problems in jQuery

I created a login for my application, but I'm having a problem with the return. The user and password panel sends the request to the php login (which accesses the bank). The return is an 'OK', which should be validated in the code below: $('...
asked by 22.05.2016 / 17:52
1
answer

Curiosity - PHP and Data Query Limit

Today while doing a query by type PhpMyAdmin SELECT * FROM tabela , I noticed that after a query in the database the query automatically gets the LIMIT , in this way SELECT * FROM tabela LIMIT 0 , 30 , that is, if I am correc...
asked by 05.05.2016 / 21:42
0
answers

Access - put data from a table horizontally

Hello I already researched several forums, but I could not find a satisfactory solution. I have the following table: ID COD VLR_REEMB N_FICHA DT_RECEBIMENTO 1 1 4.022,06 965 24/09/2010 2 3 6.600,00 746 17/09/201...
asked by 19.05.2016 / 23:16
0
answers

like% TEXT% in full text search

I would like help with search using full text search in SQL Server. Today I have a table that stores materials and I'm doing a search using the full text search with contains SELECT * FROM MATERIAL WHERE CONTAINS(MAT_D040I1, '"FUSO*"' ) Wit...
asked by 11.04.2016 / 20:46