Questions tagged as 'stored-procedure'

Tagged questions
0
answers

Problem to load Store Procedure with ADO.NET

I am developing an ASP MCV web application with C #, to link my application to a SQL Server 2012 database I have used ADO.NET and I have created a Model.edmx as shown in the image: The problem that occurs to me is that I do not see all the...
asked by 19.04.2018 / 22:05
0
answers

Summon procedure stored in sql from Java

I would like to know what I am doing wrong, by returning a ResultSet that executes a stored procedure that performs a select on a sql table. I'm working on Java I have a java project that serves as the data layer where I connect to the databa...
asked by 17.04.2018 / 19:30
1
answer

how to create a SQL table with dynamic columns

How can I make a dynamic SP where according to the data of a table1 I take them as columns to create a table2 these may vary . That is to say how there can be 1 or 2 there can be 10,20,30 ... I leave a SP to create a table CREATE PR...
asked by 13.04.2018 / 21:40
1
answer

Immediate error when executing stored procedure from the beginning of the Script

I'm trying to run a Stored Procedure on Toad for Oracle 12.12 but I have not succeeded. I hardly execute the stored, I miss an error from the word Declare, I would appreciate your help. DECLARE -- Declarations var_P_NROTRA NUMBER;...
asked by 12.04.2018 / 00:36
0
answers

{"Error parsing column 6 (Birthdate = 1 - UInt64)"} DAPPER

I'm using DAPPER with JSON and C # where I'm looking to update 2 tables of a database made in MYSQL: PERSON and MASTER ... Then I leave the fields of both objects in C #, the setting of the JSONs that I use to insert, the fields of the tables an...
asked by 15.04.2018 / 00:41
0
answers

Use stored procedures to make calculations between 2 tables.

I have these two mysql tables, one of routes. Sales table: What I'm looking for is to implement a stored procedure, so as not to burden the php application so much. Let the process take as inputs: * tabla_rutas.num_corrida,...
asked by 31.03.2018 / 04:28
1
answer

Problem when capturing a data by SQL Server stored procedure

I am working with this table in SQL Server 2014: create table suceso ( id int identity (1,1) not null, codMod varchar (10) not null, fecha date not null constraint pk_suceso primary key (id) ); go And this is the stored procedure:...
asked by 21.03.2018 / 13:04
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 / 08: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 / 16:59
0
answers

How to send a string to the IN clause in the stored procedure (oracle)

I find myself doing select to a table by means of where campo in (id1,id2...) . My doubt arises in how to send the string as an input parameter to the Oracle stored procedure. Then I present what I have tried so far. From C # I s...
asked by 23.02.2018 / 02:03