Questions tagged as 'stored-procedure'

Tagged questions
0
answers

Create Array in a stored procedure

I am migrating a stored procedure from Oracle to Sql server and I have this problem. It turns out that they occupy a varray within the code. I do not know how to do it in SQL. Searching for different pages, some recommend that a table be made...
asked by 12.02.2018 / 23:43
1
answer

Pass Array with numbers to SqlServer, split and insert the data

Here I bring my problem. I use SqlServer 2014 and VisualStudio 2015 I have an Object named CashRegister which has these attributes: public class CashRegister { private static CashRegister CashRegisterInstance; public int? Id...
asked by 16.02.2018 / 18:38
2
answers

Error trying to filter records using a stored procedure

I'm trying to filter records using a stored process and when I start entering the title of the record in the textbox I get an error. Alamacenado procedure CREATE PROCEDURE filtrar_articulo @filtro varchar(45) AS BEGIN SELECT titulo,...
asked by 04.07.2017 / 17:23
0
answers

Do stored procedure with a tour of another table

Good afternoon community. I am a beginner in this of the stored procedures, and I would like to know some way to do the following: I have these 2 tables: Balances saldoid|cuentaid|deudas|abonos|mes -------+--------+------+------+---...
asked by 14.03.2017 / 00:30
0
answers

Because my stored procedure does not return values to my php

I have a small problem, The execution of my stored procedure from my php does not return values: $op=1; the variable $op contains the number of my procedure the variable $cadena contains the search for the where $S...
asked by 11.08.2016 / 16:45
2
answers

How can I compress into a .zip file and then delete the original files

I have a program that calls a stored procedure which works well. The result of this, gives me 10 files with the name of the different projects. What I'm trying to do is to be able to compress those 10 files and make a single .ZIP file that...
asked by 18.08.2016 / 20:10
2
answers

Error Timeout ASP.NET SP

I have a detail when loading the StoredProcedure and fill in a datatable , I mark the error:    "Timeout expired The timeout period elapsed prior to completion of the operation or the server is not responding The statement has be...
asked by 16.08.2016 / 19:31
1
answer

Call several stored procedures inside another

I have a question about how to call several stored procedures inside another in Oracle. I tried to call them in the following way, but I only run the first one. Does anyone know how I can make the call for all three to run? I am using Oracle PL...
asked by 08.02.2017 / 18:58
1
answer

C # Does not execute stored procedure + trigger

Friends how are you! I have a stored procedure that inserts records in a table, which I run from a WinForms application, I was making some modifications and I added a Trigger to the table to which the procedure inserts the data. But alread...
asked by 14.06.2018 / 16:22
1
answer

How to call a stored procedure inside another

As I can solve this problem, I am trying to call a stored procedure inside another, this is the code that I have done so far, in the first image the stored procedure works (SP_SELECTINVENTARIO) in the second is the problem that I have , how can...
asked by 17.11.2017 / 19:15