Questions tagged as 'sql'

Tagged questions
1
answer

SQL to check skipped number

I have a table with 12,560 records from 5 years ago, that is, it does not have such a good modeling and it has a field called 'code' that the user filled with something like CA-0001. The problem is that at some point in the history of this datab...
asked by 23.06.2017 / 18:32
1
answer

Search for information not directly related to the database

I would like to select the AuthorName , AuthorName , Book_Title attributes from a database that has the Book, Author, and Publisher tables, and EditorName of tables that are not directly related (so to speak), this is the bank structure;...
asked by 12.07.2017 / 02:23
0
answers

Calculated field in Java

I'm doing a Java project and I have a database with two tables and one with a calculated field. The calculated field is of type "time" and was done with the UPDATE nome_da_tabela SET Nome_do_campo = TIMEDIFF(hora2, hora1) I have two prep...
asked by 23.06.2017 / 13:17
1
answer

Problem in returning the query

I have a problem with my return from the query. public IList<Rota> Lista() { //* string hql = "SELECT * FROM Rota WHERE ORDER BY Km_Atual ASC"; string hql = "SELECT Km_Atual, MAX(DtLancamento) FROM Rota GROUP BY I...
asked by 22.06.2017 / 20:41
1
answer

How to create a SQL function that calls a script in python?

I need to create software that each insert into a table a script in python detect that there has been change in this table and execute certain commands. I've already done an implementation that stands all the time testing if there was a change i...
asked by 22.06.2017 / 19:58
2
answers

Recover image in SQL SERVER and put in a REPEATER list

Today I retrieve information from a database and ready a REPEATER, so far everything blz. But I also need to get an image of the database and show in this REPEATER. Below is how I show the table. SoIwanttoputacolumnwiththeimage.Belowclass...
asked by 16.06.2017 / 04:27
0
answers

Calculated field

Good afternoon, I have a database made using the phpMyAdmin tool, but based on SQL. The database has a table that has a calculated field. The table has 6 records, but when I make the command for the calculated field, this command does not...
asked by 14.06.2017 / 16:47
1
answer

"ORA-01417: a table may be extra joined to at most one other table"

I'm setting a select and I came across the following error:    ORA-01417: a table may be extra joined to most other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO, D.SEQCONTRATO, E.PERCDESCONTO, D.SEQCONTRATO, E.SE...
asked by 26.06.2017 / 23:17
1
answer

Delete Button and Editable Fields (PHP, SQL, HTML, CSS)

I'm new here, student of computer science and programming internship ... I do not know much about how the forum works, but I have a pertinent doubt that I've reviewed Google several times and still can not resolve, even if it's a bit simple =...
asked by 09.06.2017 / 14:48
1
answer

.NET CLR - ERROR - 9521 exceeds the maximum accepted message size of 4,000

My code makes a post to a webapi from a trigger in an SP that monitors my database. This POST works fine for msgs of up to 4000 characters but above this the SP of this error: "ERROR -> 9521 exceeds the maximum accepted message size of 4,0...
asked by 09.06.2017 / 16:24