Questions tagged as 'stored-procedure'

Tagged questions
1
answer

I return the value of Stored-procedure in SQL

I just made a Store procedure on sql server. This is the structure. USE [AuditoriasDB] GO /****** Object: StoredProcedure [dbo].[spFindOrInsertSucursalProveedores] Script Date: 18/08/2018 01:23:58 p. m. ******/ SET ANSI_NULLS ON GO SET QUO...
asked by 18.08.2018 / 21:28
0
answers

How to define an attribute of type DateTime in python

I would like to know how to set attributes in python within a class. And tried the following code: def __init__(self): self.fecha_Y_Hs = datetime.datetime.now() self.decripcion = '' I am new in this language and I would like to know...
asked by 09.08.2018 / 22:56
1
answer

Procedures stored in C # [closed]

I am scheduling a login in C # with user validations by Procedures stored in SQL Server . I'm trying everything and it does not give me a result. I would like to know if someone could help me with the code. Clase de validacion en C#:...
asked by 26.07.2018 / 03:55
0
answers

Stored procedure with Declare and Set phpmyadmin

I try to do a stored procedure by declaring a variable that stores a data, but apparently I have an error. Procedure: create procedure insertarempleado ( cedula varchar(10), pass varchar(15), nombre varchar(30), apellido varchar(30)...
asked by 09.07.2018 / 05:30
0
answers

How to do a procedure stored in mysql that inserts the id from one table to another?

How to do a procedure stored in mysql that allows to validate if a repeated data is found and if so to be able to register in two related tables otherwise insert only the id in a table? I have the following SQL script works if cc is not found...
asked by 06.07.2018 / 03:58
0
answers

Error in MySQL stored procedure with variable VARCHAR

The problem is the following: I have an SP in MySQL that receives a variable of type VARCHAR to make a query using the received variable and return a table, the SP worked, all I did was erase the database because I had some problems in some tabl...
asked by 28.06.2018 / 01:30
0
answers

Stored Procedure executed within another with two outputs to be assigned to a variable

Dear, I am running an SP in Sybase that executes another SP according to certain conditions, this SP will have two output values but only one of them will be output in each execution, my problem is that one of the two values will be print withou...
asked by 15.06.2018 / 15:30
0
answers

How can I insert multiple records in a single stored procedure?

Hello, how are all my questions? Is it possible to send a stored procedure in this way: CALL SP_CLIENTE((1,'pepito','perez'),(2,'alan','brito')); for (let i = 0; i < xml.length; i++) { datosJSON.push({ 'id': info.replac...
asked by 06.06.2018 / 18:45
1
answer

Stored Procedure Laravel

How do I insert records into two related tables from a stored procedure in laravel? That is, register the user and then retrieve the id to insert information in another table.     
asked by 31.05.2018 / 04:00
0
answers

I wanted to know if I was wrong in creating the USP ConsultBook or in business entities

   When I want to update a book, the combobox of the Book goes blank (supposedly I should leave with the data of the book) but when I display the list of authors, categories, etc, and when I change the year of publication or Title of the book I...
asked by 30.05.2018 / 19:37