Questions tagged as 'sql'

Tagged questions
4
answers

LEFT JOIN does not return NULL values

I have two tables: AppWindowsEvent: CREATE TABLE [AppWindowsEvent] ( [idAppWindowEvent] INT IDENTITY(1,1) , [idAppWindow] INT , [idMill] INT , [idEventType] INT , [Order] INT , CONSTRAINT PK...
asked by 28.09.2016 / 16:15
2
answers

Problems reading Excel SQL Server 2012 file

The error returned by the statement is:    Msg 7303, Level 16, State 1 sql server 2012 Microsoft.ACE.OLEDB.12.0 SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0' ,'Excel 12.0 Xml;Database=\path\archivo_excel.xls;HDR=YES'...
asked by 14.10.2016 / 20:30
2
answers

java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

I have had a problem when returning a value of BD mysql null in '0000-00-00' format The error that occurs is:    exception       javax.servlet.ServletException: java.sql.SQLException: Value '0000-00-00'> can not be...
asked by 31.03.2017 / 23:05
1
answer

C # Stored procedure or function expects parameter which is not supplied

I get the error    'sp_InsertaLandingPageTest' expects parameter '@IDUSUARIO', which   was not supplied, l id is supposed to be generated from the maximum but I really have no idea how to do it if you insert data into the stored procedure...
asked by 24.04.2017 / 19:31
2
answers

Synchronize data between two databases with the same structure

I need to pass the data from one database to another with the same structure, the problem is that both databases are in use, in both you can insert different records and they are in different places. For example: in DB1 we enter an invoice fr...
asked by 26.05.2016 / 16:47
1
answer

BD Primary fields in varchar

Good day I have a question, I'm working with 2 databases at the same time, to make a table, it works well I did some joins and it brings me the data, but, there is a data that does not bring it to me, and I was verifying and the only thing I fou...
asked by 18.12.2018 / 16:34
2
answers

SQL Sort by ID and value in 2 different tables

Currently I need to make a query to 2 tables where the data have several equal columns. The problem is that the ordering must be done based on how the order of table A is structured, but at the same time taking the value of the ValueOrder column...
asked by 05.05.2016 / 22:46
1
answer

Run 3 queries in JAVA

I want to make 3 queries within a method in JAVA in order to assign a serial number to my record that has the ID number as consecutive, this is my code. public void guardar() { String erp = jComboBox1.getSelectedItem().toString(); String...
asked by 13.09.2018 / 01:44
0
answers

Tabledit with jquery does not work well

I'm trying to learn how to create editable tables with jquery.tabledit.min.js but I'm really not aware of where my judgments are failing. My table "testC" is: id fisrt last 1 juan a 2 pedro b 3 diago c and my index that I am try...
asked by 21.08.2018 / 19:33
1
answer

Duda Active Record

I am doing a job for the university they are introducing us in the "Active Record" pattern in C #. The thing is that I have a class called Persistente , let's say the base class from which all the others inherit. It contains methods such a...
asked by 20.03.2018 / 08:08