Questions tagged as 'sql'

Tagged questions
1
answer

Compare an Input with a record in a bbdd

We imagine that I have this form (It's much bigger but I want to try just one field): <form id="form1 " action="?action" method="POST"> <tr> <th style="text-align:left;">Acronimo</th> <td&...
asked by 14.05.2017 / 19:29
1
answer

Problem when making inquiries in psycopg2

good day I'm working on a project where I need to consult different databases and for that I use the psycopg2 extension of python, however at the time of making a query it only shows me the first data of it , despite the fact that there is a lot...
asked by 03.05.2017 / 22:37
1
answer

SQL - Update multiple columns in several rows of the same table

I work with NodeJS and SQLite , seeing my use of the I / O of the SSD disks on my Azure server (which were extremely high), I would like to make a serious optimization. My table has the following format: ID points...
asked by 18.04.2017 / 20:17
1
answer

sql query in mysql shows repeated records

I have a query in which I want to get the name of a course when a field is different the problem is that it shows me repeated records know what the problem could be. the query should only show courses that you do not have assigned tables...
asked by 16.04.2017 / 22:11
1
answer

Is it required to have excel installed to use OPENDATASOURCE? [closed]

Good morning, in the following link I found the way to import data from an Excel to SQL Server: link However, since the application from which I am going to execute said command is in PHP, I would like to know if it is necessary that in...
asked by 26.04.2017 / 17:43
1
answer

Problem with Crystal Repots reports when connecting to server

I have a problem wanting to generate reports from a database that is on a server, what happens is that when I perform local tests, I can generate the reports without problems, but when I try to assign it to the "ServerName" parameter in my code...
asked by 27.04.2017 / 18:49
1
answer

Print two queries in the same "td" or "select"

Good morning, I'm doing a CRUD, and right now I'm making a table where I can select modify or insert users, well I come to the conclusion, that when I pass the table to users they choose for example which user they want to select, but they can o...
asked by 27.04.2017 / 08:55
1
answer

How to use the LIKE as a parameter in a function in postgres

Hello everyone, I am trying to pass a query that I use regularly to a function but I run into problems to create it. What I have so far is the following CREATE OR REPLACE FUNCTION "public"."prueba" (in regional varchar, in fecha date) RETURNS...
asked by 10.04.2017 / 22:31
2
answers

Add or subtract the time difference between two dates in java

I need to add or subtract the time difference between dates, If the ESTADOLINEA is 1 add, and if the ESTADOLINEA is 2, subtract the time. This is the SQL table: My idea is to loop through the records This is my code:...
asked by 03.05.2017 / 11:54
2
answers

How to select a range between dates to avoid an SQL insert?

I have a table called etapa which has id_etapa, etapa_inicial, etapa_final ... what statement (sql) can I make to show the stages that are between the etapa_inicial and the etapa_final ? since the idea is that if the...
asked by 28.03.2017 / 17:51