Questions tagged as 'sql'

Tagged questions
1
answer

SQL database for multiple users [closed]

Well, I have a question. I'm developing a web application that will serve more than one user, however each user has different data recorded in the database, and this volume will be great since the system is for sales management. I would like...
asked by 03.06.2015 / 19:47
1
answer

How to execute a procedure in a select?

What I tried was the following, and my procedure returns only a select: SELECT * FROM t_usuarios WHERE nome like '%jeniffer%' AND cd_usuario IN (exec usp_lista_emprestimo_em_atraso) ORDER BY...
asked by 31.05.2015 / 21:04
2
answers

Error fetching Time and Date

I am registering in the MySQL database values such as time and date. Code JAVA : public String getDataPedido() { StringBuilder horaSistema = new StringBuilder(); GregorianCalendar pegarHora = new GregorianCalendar(); hor...
asked by 03.06.2015 / 17:09
1
answer

Firebird - transaction monitoring

I updated my Firebird to versão 2.5 and would like to view the transactions, I saw in several links that the command: SELECT * FROM mon$statements resolves, but this command gives me an error:    Undefined name. Dynamic...
asked by 18.05.2015 / 14:23
2
answers

Combobox come blank VB.NET with INNER JOIN

I have the problem here and I have not found the solution yet, I am loading data in a combobox using a DATASET from an INNER JOIN done in a database SQL SERVER . So far so good that as soon as I get the cong, I would like the other combobox...
asked by 18.05.2015 / 00:26
1
answer

Java project with Oracle and MySQL at the same time?

Given an Oracle Database and a MySQL DB, and the impossibility of integrating both databases: Would it be possible, for example, to class my application 'look' at the mysql table and update an oracle table?     
asked by 04.05.2015 / 19:15
1
answer

JPA - Two OneToOne and OneToMany relationships between the same class

I have a Student class and it has two relationships with Pessoa a OneToOne and OneToMany and person in turn a relationship with Endereco , as shown below: Student Class @Entity @Table(name = "ESTUDANTE") public cla...
asked by 29.04.2015 / 13:27
2
answers

How do I convert a SQL Server backup file in .BAK to .CSV?

The file was generated from SQL Server. I would like to convert it to a visual file, type .CSV, is it possible?     
asked by 03.07.2015 / 15:26
1
answer

Sql last ids

How do I return the last 5 id with sql? NAME ID 1 John 2 Guilherme 3 Alberto 4 Alexandre 5 Michael 6 Lucas And it will return: 2 Guilherme 3 Alberto 4 Alexandre 5 Michael 6 Lucas     
asked by 03.07.2015 / 22:51
1
answer

Problem to add values in JDBC

The console gives me the following error:    FUNCTION workday. SUM does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual Can only sql be in my prepareStatement, help me! Dao method publi...
asked by 04.07.2015 / 01:21