Questions tagged as 'sql'

Tagged questions
1
answer

Declare scalar variable

I have the following sql code CREATE PROCEDURE AddUsuario @uNombre NVARCHAR(50), @uPass NVARCHAR(50), @responseMessage NVARCHAR(250) OUTPUT AS BEGIN SET NOCOUNT ON BEGIN TRY INSERT INTO usuario (id, nombre, pass, fecha_alta) VALUES...
asked by 17.03.2018 / 07:09
0
answers

Error loading data from one table into another - SQL Server 2014

I have the following stored procedure which I use to fill the Resources table. To load the Resources table, I get the IdEntity that I bring from a datagrid that contains a list of accounts. The problem is that when loading the data in the Resour...
asked by 13.03.2018 / 15:59
0
answers

Give order to MenuStrip

I have a question, I have a MenuStrip with several elements and I wanted to know if there is any way to follow an order to enter each element, I explain: I want you to first enter the "lines" tab and then the "part number" tab and the "condit...
asked by 26.03.2018 / 22:54
1
answer

load crystal reports with gridview data? [duplicate]

I have a gridview in asp .net filled with a datatable and I need to click on a print button to generate a report crystal reports with the gridview data. I was investigating and apparently it is with a "typed dataset", I do not understand very...
asked by 14.03.2018 / 18:20
1
answer

problem when executing SQL statements

I'm finishing a project, which in a window designed with Java, and within this window with two textArea and one button. You write some SQL statements in the textArea, you select the one you want to execute and when you click on the button depend...
asked by 11.03.2018 / 00:03
0
answers

Should I add the conditions of the Select Case to the Where?

I have the following sentence, my question is: if I want to optimize the response time, should I add the conditions of the Case to the Where? the ordering field of my table is Cedula and there are types of products that interest me, my question...
asked by 15.03.2018 / 16:04
0
answers

Update SQL Pasted

I have a PHP function where I read an excel file with two columns in the A are some numbers of guides and in the B to the group (template) that you correspond example     A B 8701514 72 8701515 72 8701516 73 8701517 73 after reading the fi...
asked by 08.03.2018 / 23:01
0
answers

How to subtract records from the same field in Report Viewer?

The following report, brings the following query: In the report, how can I subtract the amount? When I try to put a TextBox and put it in this way it gives error: = (Fields! MONTO.Value - Fields! MONTO.Value, "dsEstadisticos")    ...
asked by 08.03.2018 / 14:35
0
answers

How can I solve this problem? error # 1235

This error appears when I try to insert into two tables at the same time using the t3 detonator. Here's the code: drop trigger if exists Actualizador; delimiter go CREATE TRIGGER Actualizador AFTER INSERT ON banca FOR EAC...
asked by 05.03.2018 / 20:52
1
answer

SQL result in PHP as String

I'm trying to put the result of an SQL query in a string, concatenating the results. $poblaciones = $wpdb->get_results('SELECT poblacion FROM wp_custom_poblacion WHERE postal = (SELECT cod_postal FROM WPCalidad.wp_custom_proveedores OR...
asked by 12.03.2018 / 10:27