Questions tagged as 'stored-procedure'

Tagged questions
1
answer

Differences when executing stored procedure in local and server

I have the following stored procedure, which I run locally in Workbench and do what I need; however, I have the same database stored on a test server, and that's where I get the following message when I run it:    MySQL returned an empty resu...
asked by 28.03.2017 / 02:09
1
answer

How to call a Store Procedure that returns a list of data in the Entity Framework Code First?

I need to show a list in a DataGridView but due to the complexity of the SQL query I prefer not to use Lin-Q so I create a stored procedure but since I use the Entity Framework I do not want to call using SQLConnection but from DbContext.     
asked by 09.01.2017 / 02:12
2
answers

Error converting nvarchar data type to date - SQL Server

I am generating a cross table where I show the operators and every day of the week with the number of tickets they attended per day, in this case I am creating a function that receives a date parameter and calculates each day of the week for so...
asked by 11.01.2017 / 00:54
1
answer

Storage procedure with case

I have this Stored Procedure where I need to search by maternal or paternal surname Bearing in mind that in my grid both concatenated are shown as surnames, as is in the select But doing it with the case complicates me since I can not have...
asked by 19.12.2016 / 22:04
1
answer

Refresh list item c #

I am filling an object of type Celda public class Celda { [DataMember] public int celda_id { get; set; } [DataMember] public string celda_codigo_empresa { get; set; } [DataMember] public string celda_modulo_codig...
asked by 26.10.2016 / 20:14
2
answers

MySQL: Function to determine if an ID exists

I need to do a mysql function that returns true if an id exists, I must send 3 parameters, name of the table, field name and value, if there is a record in that table that is identified with the value received in the specified field of the table...
asked by 12.09.2016 / 05:21
1
answer

traverse 12 csv files with UTL_FILE

Friends, this is the code I'm doing to go through 12 CSV files, but you're only reading the last file, you can help me PROCEDURE SP_CARGA_POLY_EXTERNA (V_ERROR OUT VARCHAR2, V_MENSAJE_ERROR OUT VARCHAR2) IS V_SECUENCIA NUMBER :=1;...
asked by 31.10.2018 / 22:16
1
answer

Problems with my Store Procedure, do not insert values with json

I have a problem with an SP, what happens is that when you run it, it receives a json as a parameter, and when it is executed, it returns a false message as an error message, this is my code, I am not Very much in this since I am learning: CRE...
asked by 10.10.2018 / 23:43
0
answers

Error calling a stored procedure (MariaDB) with parameter in Laravel 5.6

I have not managed to execute a stored procedure with parameter. Specifically I get this error: "SQLSTATE [42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB...
asked by 04.10.2018 / 23:18
2
answers

stored procedure does not return response [mysql]

Hello all good morning, I have to do a search in a form of c #, for this I have a procedure stored in MYSQL that will show the results of a certain word entered in a textbox, the issue is that the sp does not return any result, the procedure cod...
asked by 14.08.2018 / 17:27