Questions tagged as 'stored-procedure'

Tagged questions
1
answer

Stored procedure in LinQ c #

Hello developers good day, I am with a problem it turns out that my project does not have to have any stored procedure in SQLServer and they asked me to do everything from linQ the issue is that I have not found how to create the...
asked by 25.04.2018 / 18:02
1
answer

Verify the name of a varchar field and concatenate an int in case it already exists

I am reprogramming a calendar to save tasks to perform and I need a stored procedure that allows me to verify if the name of the task exists in the 'subject' column of my Appointments table, if it exists it must modify the name adding it at the...
asked by 11.08.2017 / 15:03
0
answers

triggers or mysql stored procedure [closed]

I am carrying out a project of industrial warehouses and warehouses but I have a doubt when making the registration of contracts. When I register a contract, I occupy a warehouse that is identified by its id. The problem comes when I register 2...
asked by 28.11.2018 / 06:09
3
answers

create table with stored procedure

I'm trying to create a table with the name of a parameter given to store procedure: CREATE PROCEDURE INTENTO3 @table varchar(50) AS BEGIN create table @table ( campo1 varchar(20) ) END I always get t...
asked by 12.04.2018 / 21:02
1
answer

Stored procedure invoking dll

I have to create a stored procedure that receives one parameter and returns another. Within the procedure I declare a variable and give it value with a select. Later with the input variable and the one obtained from the select I invoke a dll. I...
asked by 22.11.2016 / 11:55
1
answer

Syntax error in Stored Procedure

I have a problem compiling, what happens is that it generates syntax error, the detail is that I'm just learning from stored procedures, look at this is my function: Note: I edited my question and it was already executed correctly, only that...
asked by 09.10.2018 / 19:19
2
answers

Create Stored Procedure to fill a table

I have a mobile application that calls different services that I have in c# with Wcf . The issue is that I have one of those services in which the user from the mobile sends an object called Medicion . This object has a list o...
asked by 09.11.2016 / 23:33
1
answer

sp_rename in SQL server inside an exec

I want to use the sql server sp_rename function, the problem is that I have to put it inside an exec, since the database on which it runs is dynamic and I have it inside a cursor. The fact is that the following sentence works correctly: EXEC (...
asked by 25.04.2018 / 18:32
1
answer

Search with stored procedure

Good morning classmates I have a stored procedure to search by code and it works fine but I would like to know if there is a way that by searching for example the 1.5 in addition to looking for those with the 1.5 also drag the record with code 1...
asked by 05.07.2017 / 15:24
4
answers

Register sale with its retail detail through transactions in a stored procedure MYSQL

I'm trying to register 2 tables through transactions in MySQL and I have a table VENTA , to which I put as a field the field id_venta and is type int autoincrement, plus I have the table DETALLE_VENTA , which has as FK...
asked by 01.07.2016 / 20:01