Questions tagged as 'sql'

Tagged questions
1
answer

Save image in blob or by route? [closed]

What would be most appropriate and a good practice to save images in database By route or within the manager as data     
asked by 25.10.2017 / 13:23
1
answer

Sql query of dates

I have to make a Sql query and only should show what from now on what is with a previous date can not be displayed. I have the problem that if I put it with DATETIME format it takes me the minutes and when I do the select what I just insert...
asked by 05.11.2017 / 21:07
1
answer

Where and how the error in this line of SQL and Java is corrected

PreparedStatement pps = cn.prepareStatement("UPDATE tb_producto SET cantidad='"+txtcantidad.getText()+"' WHERE nombre='"+txtbuscar.getText()+"'"); Where is the error and how to solve help please!     
asked by 23.10.2017 / 02:04
1
answer

Error filtering SQL query

It is assumed that this query has to filter for all the conditions that are after the where or combine the conditions but, when I put a date range, a name and an interaction title, the data does not they filter as they should. SELECT DI...
asked by 25.10.2017 / 03:06
1
answer

Insert in SQL fields not null

Hi, I have the following question. It's something very basic but now it has me stranded. I want to make a query to a table from sql server managment. The problem is that I have the Id that turns out to be primary key, not null and it is self-inc...
asked by 18.10.2017 / 21:30
1
answer

Insert SQL query with AJAX and ASP.Net

Hello, I need to do a SQL INSERT using ajax in ASP.NET, I'm not sure what I'm missing. $('#submit').click(function () { insertFeedback(); }); function insertFeedback() { var modelx = new Object(); var depS = documen...
asked by 18.10.2017 / 23:38
2
answers

SQL Server, query data from a table using joins

Good, I need help because I can not find a problem, I have a table 'A' of meetings and a table 'B' of users, table A contains a field called 'Organizer', which stores the Login of a user (eg: Juan Perez, your login it's 'jperez'). Table B stor...
asked by 16.10.2017 / 22:04
1
answer

Avoid getting out 0.00 in SQL server query

I have this query and send a 0.00 data and I do not want to be killed my query: select Descuento = isnull(( SELECT sum(x.Valor) FROM Cuenta x where x.IdSer between 25 and 39...
asked by 01.11.2017 / 16:27
1
answer

SUM AND COUNT in a query with left join in MYSQL

I have a problem when generating a query in my DB, I am going to explain in an abbreviated form the structure of the tables I want to make this query: **tbl usuario** - id_usuario - nombre **tbl alquiler** - id_alquiler - importe_total...
asked by 02.10.2017 / 19:06
1
answer

SQL query with 4 related tables

I am learning SQL to make queries and I still do not understand very well how to do them with tables that are related. My 4 tables are the following ... First table: create table empleado ( id int IDENTITY(1,1), nombreempleado va...
asked by 02.10.2017 / 02:50