Questions tagged as 'stored-procedure'

Tagged questions
1
answer

Return ID registered in a procedure stored in mysql

Hello, I have the following code in php which makes the registration of a sale what I want is to perform the following action. Return the id of the record stored in the DB $query = "CALL sp_insert_venta(:tipo_pago, :tipo_comprobante,...
asked by 30.11.2018 / 22:19
0
answers

It says that there is no volatile table created in a store procedure in teradata

I'm creating a stored procedure in teradata , where in I created a volatile table that I then call to do a data insertion. I do not know why the volatile table does not recognize me, can you help me? Script: replace PROCEDURE ship...
asked by 27.11.2018 / 21:19
0
answers

Connect SQL Server with Macro in Excel

on this occasion I want to request your valuable help. I have a stored procedure with 3 parameters in SQL and I need to create a Macro in Excel with 3 text fields that will feed the parameters. Then, I must collect the result of the Execution of...
asked by 22.11.2018 / 23:38
0
answers

# 1329 -No data-zero rows fetched, selected, or processed

Good day I have in my database (MySQL) the following table: To obtain the balance of an account on a certain day, I use the following query: SELECT (@total := @total+IFNULL(SUM(tcc.consumo),0.00)-IFNULL(SUM(tcc.pago),0.00)) saldo FROM t...
asked by 15.11.2018 / 18:37
0
answers

Migrate Triggers to different databases in Laravel

I have a problem, it turns out that I work with laravel and migrate several tables to different databases thanks to Schema :: connection in a normal way, but the problem is that I also have some TRIGGERS and PROCEDURES as migrations using the...
asked by 12.11.2018 / 20:53
0
answers

Error filling form :: select () from query with stored procedure

I have a problem filling out a Form :: select () with my stored procedure, I'd like you to help me what I'm doing wrong: This is my procedure stored in MySQL: CREATE PROCEDURE getSucursalCombo() BEGIN SELECT nombre, id FROM sucursales WHE...
asked by 08.11.2018 / 19:03
0
answers

sql query by multiple MYSQL columns

I want to consult by several columns with a concatenated value, I put the following example to make me understand -- Como se llamaría => CALL sp_getSuperConsulta("%val1% %val2% %val3%"); DROP PROCEDURE IF EXISTS sp_getSuperConsulta; DELIMI...
asked by 20.11.2018 / 23:24
0
answers

how to pass multiple values in a single parameter in stored procedure oracle plsql

friends a query how you can pass multiple values in a single parameter in a stored procedure with Oracle plsql     
asked by 30.10.2018 / 15:01
1
answer

the procedure is fine with an output (phpmyadmin)

How about? I have a doubt I want to make a procedure so that the end result of a result 0 or 1 according to the result number of my table users the procedure is this: DELIMITER $$ CREATE PROCEDURE Coretec_ConfirmUser(IN p_user_mail VARCHAR(150...
asked by 28.10.2018 / 00:16
0
answers

SQL Trigger in Stroed procedure - activate trigger after using sp

Suppose I have a very simple stored procedure , which performs a select , but I want to make a trigger that is activated every time I use that stored procedure . Does anyone know exactly how to do something like that?...
asked by 27.10.2018 / 01:40