Questions tagged as 'sql'

Tagged questions
1
answer

Loop to perform updates on several DBs at the same time?

I'm looking for a way to make the same change to different databases that start and end with the same syntax, just change the base number. I have the following code but it does not work for me, just update the first Base DECLARE @numero_alu...
asked by 13.12.2017 / 12:46
1
answer

Error executing query in php

Good, I am trying to separate a query from a web page in different pages but at the time of making the query I get the following error:    Fatal error: Uncaught PDOException: SQLSTATE [42000]: Syntax error or or   access violation: 1064 You h...
asked by 06.12.2017 / 23:03
1
answer

"AWT-EventQueue-0" java.lang.NullPointerException

I am generating this code: public void llenarTabla(){ this.modelSalon = new DefaultTableModel(){ public boolean isCellEditable(int row, int colum){ return false; } }; this.modelSalon.setColumnCount(0); this.modelSal...
asked by 02.12.2017 / 01:49
1
answer

Show the result of a SQL Server 2008 sp in a web form C # (Visual Studio)

Good day everyone. I have a sp SQL Server 2008 that throws me the following result: Total_Registros 1 On the other hand, I have a form that contains a label (lbl_totals), nbsp;&nbsp; <asp:Label ID="lbl_totales" runat="server...
asked by 01.12.2017 / 18:38
1
answer

mySQL - Can you do something similar to INDEX + MATCH?

Good morning, I need to update data in bulk in mySQL tables. What I have: Tabla1 => Donde quiero actualizar datos, tengo 2 columnas, ID1 y VIEJOTEXTO. Tabla2 => Una tabla con 2 columnas, ID1 y ID3. Tabla3 => Tabla donde tengo que...
asked by 28.12.2017 / 16:38
1
answer

subConsulta select transformed to DQL

I am using MySQL and I have this select : Select TOP 15 Item DescriptionforSales , (select top 1 Retail from Pricelist where Pricelist.peachitemid = products.peachitemid ) as Retail " From products where imagen=1 and active=1...
asked by 26.11.2017 / 22:17
0
answers

doubt in FREETEXTTABLE and its KEY

I am using FREETEXTTABLE, however, when I try to do the inner join, the result is empty, showing me nothing at the end, although it does not make me an error either, it simply marks everything as empty. SELECT * FROM FREETEXTTABLE(dbo.tabla1,*...
asked by 27.11.2017 / 09:45
0
answers

Show Hyperlink to SQL to Excel

I have searched everywhere like activating a hyperlink obtained from SQL to Excel. Example: SELECT '=HIPERVINCULO("http://example.microsoft.com/informe/"; "Haga clic para ver el informe")' I connect Excel with sql and it brings me the re...
asked by 05.03.2018 / 20:40
1
answer

Perform query of totals between two tables without duplicating the values

I need to combine 2 tables, make a summary and get their differences. In the services table I have the cost of the service, in the payment table I have the amounts and means of payment associated, as I can make a summary in such a way that indep...
asked by 05.03.2018 / 19:55
1
answer

How can I avoid repetition of values in columns in a Mysql table?

I've already tried it with UNIQUE and CHECK but it does not work for me. If there is a teacher with a subject, I would like you not to put the same subject back to me, because the rest of the code I have makes it repeat. * * * for($i=0;$...
asked by 22.11.2017 / 17:03