Questions tagged as 'sql'

Tagged questions
1
answer

Substring in a comparison (ON)

Friends, I'm doing a SQL query where I have to use only part of the characters in one column and compare it with another to get the matches: SELECT A.NUMCLIEN,A.CODIDENT,A.CLAIDENT,A.DIGIDENT,C.ENTIOFI,C.CUENTA FROM GPBC.UGDTMAE C JOIN GPBC.PE...
asked by 27.10.2018 / 02:18
1
answer

Columns in mysql [duplicated]

I have the following sentence: SELECT REF FROM inv_articulo as a INNER JOIN inv_tipoarticulo as t ON a.TIPO_ARTICULO = t.PK_TIPO INNER JOIN inv_categoria as c ON c.PK_CATEGORIA = t.FK_CATEGORIA WHERE c.pk_categoria = 7 or...
asked by 25.10.2018 / 17:01
1
answer

Obtaining data from JCombobox

I'm generating a form where I need to get some value from a Jcombobox Currently, this is my code: private void llenarMatriz() { String cmb = "SELECT DISTINCT nombre_matriz FROM matriz ORDER BY nombre_matriz ASC"; try { Statem...
asked by 25.10.2018 / 16:11
2
answers

How do I verify a php variable is empty? Null [duplicated]

This would be the code, I need to know how to verify if the variable is empty or not. (comments where I need the verification) <?php include("coneccion.php"); /*************** SQL ******************/ @$buscar=$_POST["buscar"]; if...
asked by 30.10.2018 / 00:34
2
answers

I have 5 variables, I need to generate a SQL code

- Hi, it's my first posting, I hope you can understand me clearly. - I have 5 variables which are of the Bool type. True or False. I need to be able to generate a SQL statement depends on the states of the variables. I was able to gen...
asked by 19.10.2018 / 16:02
1
answer

The value of the specified String type of the data source can not be converted to the nvarchar type of the specified target column SqlBulkCopy

My problem is the following I am wanting to pass an excel file to sql server. When I take the file and I want to pass it, I throw this error:    "The value of the specified String type of the data source can not be   convert to the nvarchar t...
asked by 24.10.2018 / 18:20
1
answer

Update and Select in the same sentence

I have a sql statement where I want to join update with select but it gives me the following error: Error Code: 1093. Table 'a' is specified twice, both as a target for 'UPDATE' and as a separate source for data 0.000 sec My sentence is as...
asked by 11.10.2018 / 16:07
1
answer

Save Image in SQL Server using PictureBox

Good morning, I am working with an application within C #, which works as an inventory for the teams within the company. I'm working inside Windows Forms. What I intend to do is keep the records of each computer, with its respective image for...
asked by 15.10.2018 / 20:12
1
answer

Records of a table and look for them in another Access

I insert the image so that it looks correctly. To say also that in the t1 there may be data in the column minutes that are not exact for example Minute 17 second 32 but this for me is an erroneous record and should not appear in table t3....
asked by 05.04.2016 / 12:32
1
answer

SQL problem to add rows SQL SERVER

I need to add the salaries of the next query I have and sort them by description. select distinct cp.descripcion, cp.idSysCPPuestos, em.sueldoDiario, em.sueldoIntegrado, em.idSysCPCentroCosto --,sum(CAST(em.sueldoDiar...
asked by 23.10.2018 / 17:31