Questions tagged as 'sql'

Tagged questions
2
answers

SQL syntax with variables

I'm building a database in Access, and I want to run an update query in vba . I know the syntax a little bit, but it's giving me a bug. The problem is that I try to pass some values to him by means of two variables, and it seems that...
asked by 13.03.2017 / 14:53
1
answer

query sql error when converting to type time?

I have the following query SELECT CONVERT(TIME, LEFT(CONVERT(VARCHAR,(DATEDIFF(HOUR,[Hora Salida],[Registro Salida]))),2) + ':' + LEFT(CONVERT(VARCHAR,DATEDIFF(MINUTE,[Hora Salida],[Registro Salida])),2) + ':00') but when I try to execute i...
asked by 19.01.2018 / 13:24
1
answer

Problem in SQL query

Good morning I am making an inquiry to know the number of rows that are currently planted and the rows that were already planted but the harvest ended and therefore the remaining plants are removed for a new planting per farm. When there i...
asked by 18.11.2016 / 18:35
2
answers

consult 360,000 codes quickly java

I have 1 main Query whose response time is optimal, the problem arises when after executing my query inside the while I execute a second query that reads the code field and queries 1 by one, here my code: $_Query ="select * from remesas"; Resu...
asked by 30.11.2016 / 17:26
3
answers

SQL Query-Repeated Data

Good! I have two tables ( VOIPCLIENTE , VOIPMAQUINA ) where in VOIPCLIENTE I have information about the clients ( CLIENTE,DELEGACIÓN... ) and in VOIMPAQUINA on the machines ( MAQUINA,EMPRESA... ). These t...
asked by 29.11.2016 / 09:45
2
answers

sql query between 2 tables

I have the person table: id nombre sexo 1 paco 1 2 elena 2 3 alien null I have the table sex: id genero 1 hombre 2 mujer Starting from the bas that is a DB of the client that I can not touch, I make the following...
asked by 08.02.2017 / 12:10
2
answers

doubt with sql query

good what happens is that I have a problem to consult a table, I have the typical table products and category where id_categoria would be the attribute that relates the tables what I can not do is bring EVERYTHING from the products ta...
asked by 10.10.2016 / 20:41
2
answers

configure sql express

When installing sql express on a server and on the same network I have a client machine with which I want to enter the bd engine but I can not, previously I had been told that the sql express has to make a configuration but the truth is not what...
asked by 28.10.2016 / 21:33
2
answers

Error Selecting Records with EntityFramework

Class that receives the query data public class EngineEntity { public string FacturaId { get; set; } public string Cliente { get; set; } public int? TipoFactura { get; set; } public double? Monto { get; s...
asked by 29.10.2016 / 14:37
2
answers

INSERT SQL and get ID (JEE)

As the title says, this is in java EE , particularly java web. However, it is a simple% SQL query: I have a table with several data, and a id autoincremental:    id, date, text. I use a servlet to add an element to the da...
asked by 14.09.2016 / 18:34