Questions tagged as 'stored-procedure'

Tagged questions
1
answer

Problem with mysql stored procedure call

I have a problem calling several times in a row (within a while) to a procedure (with the CALL nameProcedure (parameter)) from php on my website. This is the code of the procedure: BEGIN SELECT @estado := estade, @subestado := subest...
asked by 23.05.2018 / 12:01
2
answers

Is it possible to convert an Object result into an Arrangement in C #?

I have the following method: public List<AnfitrionDto> Seleccionar() { List<AnfitrionDto> ret = new List<AnfitrionDto>(); VisitantesEntities db = new VisitantesEntities();...
asked by 03.05.2018 / 22:59
1
answer

Could someone please decide if the query syntax of these tables is correct?

CREATE PROCEDURE usp_ConsultarLibro @id_Libro char(3) as Select IdLibro, Titulo, NomApe_Autor, Nombre_Categoria, Nombre_Editorial, Nombre_Idioma, Año_Lanz FROM LIBRO L INNER JOIN AUTOR A ON L.IdAutor = A.IdAutor INNER...
asked by 29.05.2018 / 11:09
1
answer

How to do a stored procedure in postgresql for login?

This is my db model in question of users It turns out that I need that with the same credentials the user can log in, the intention is to create a procedure where the server returns their user data, and teacher and administrative if it is,...
asked by 09.01.2018 / 23:30
1
answer

Error in MySQL Procedure

I am trying to perform the following stored procedure CREATE PROCEDURE insert_trabajador ( IN rut VARCHAR(12), IN nom VARCHAR(50), IN est VARCHAR(50), IN sueldo INT(11) ) BEGIN INSERT INTO trabajadores ( rut, nombre, estado, sueldo_base ) VAL...
asked by 08.11.2017 / 21:57
1
answer

Doubt to show data in c # from an sp in oracle

Good afternoon I have a question related to ac # and oracle, well I have several procedures stored in an Oracle database (Oracle 11G) in several of these some with input parameters and others that only show everything (select * From name) , my q...
asked by 23.10.2017 / 00:56
1
answer

Increased auto field with stored procedure repeats

I have a problem with my system since I generate a self-incremented code in Mysql which works well when the system is used by only one user when using it 2 or 3 users this code that I generate automatically is repeated 3 times since its first cr...
asked by 20.10.2017 / 11:49
2
answers

Invalid Column Name in a table created with Querys in a Stored Procedure

I want to create an SP with two parameters, Date and Bank, the purpose is that each bank must show (among other data) all the clients in that bank and the amount of cash that will be available in 24.48 and 72 hours. after the Date parameter. The...
asked by 09.10.2017 / 22:22
1
answer

Valid column name SQL Server-Python

I am developing a small application that depends on SQL Server and development in Python , this takes data of Sp of SQL Server that it has by default of name: xp_readerrorlog 6, 1, N'login', N'failed' As you see,...
asked by 23.06.2017 / 19:03
3
answers

Save query in temporary table with stored procedures SQL SERVER

I have a stored procedure: CREATE PROCEDURE prueba @pal varchar(45) as CREATE TABLE #param(folio int,tit varchar(max),descr varchar(max)) SET NOCOUNT ON INSERT INTO #param SELECT * from post where titulo=@pal SELECT * FROM #param; go and s...
asked by 16.06.2017 / 19:29