Questions tagged as 'procedure'

Tagged questions
0
answers

Variable is not filled in procedure

Good morning. I'm running the procedure below, which validates whether the load should run or not, and if it is not possible to run, it returns an error message stating why it did not run: declare @dtAtual date, @dtCarga date,...
asked by 27.09.2018 / 16:54
0
answers

StoredProcedure in SQL Server by passing a C #

I would like to pass a list of parameters to a procedure, how to do this process? I did some research and found that it is possible to create a TABLE TYPE and use it in the procedure parameters, but I could not use it, for example. CREATE T...
asked by 06.04.2018 / 17:35
0
answers

Procedure does not execute its loop and not the syntax error

The PROCEDURE below does not display a syntax error, but when running the LOOP it does not update the records correctly, only some are updated. CREATE PROCEDURE 'SP_ATU_ITEM_NF' () BEGIN DECLARE v_nota_antiga INT default 0; DECLARE v_itm...
asked by 11.04.2018 / 19:36
1
answer

How to delete records automatically with postgreSQL?

Recently get a project that is about a blog, the user will hold the posts of various news, however I am using the server Heroku with the free account that entitles there are only 512 Megas of space, above that limit it starts charging. At t...
asked by 27.02.2018 / 13:59
0
answers

Mysql Procedure query error

Why only stmt2 does not work? DELIMITER $$ CREATE PROCEDURE abc_produtos_total_geral( OUT v_total_geral decimal(14,2), IN v_dt_inicial date, IN v_dt_final date, IN v_table_name varchar(40), OUT v_nome_produto varchar(200)) BEGIN s...
asked by 12.11.2017 / 14:08
0
answers

Data passing performance as a parameter in stored procedure

I'm developing a system, in Java and Sybase, where I need to pass the current date as a parameter in a procedure . With this, I was curious about how to pass the date ... Is there a significant difference in performance by passing the current d...
asked by 17.11.2017 / 20:01
1
answer

Why my procedure is not being accepted, I am using mysql6.3

create procedure cadastrar_nadador (out nome_v varchar(80),out sexo_v varchar(1),out nascimento_v date,out patrocinio_v varchar(80)) begin insert into nadador(nome,sexo,nascimento,patrocinio) values (nome_v,sexo_v,nascimento_v...
asked by 18.11.2017 / 21:53
0
answers

How to return a list by passing a DVT as a parameter

Good afternoon, guys. I am writing a query method and need to pass a list of charges to my procedure to get a list of employees. I'm trying to use a TVP instead of sending a string with concatenated Ids. However, I do not know how to add the par...
asked by 10.01.2017 / 18:32
1
answer

Procedure to create database and its tables

I need to create a database for each client that performs a particular registration, so I created a procedure to do such thing. But I came across a small identification problem. When I run procedure it creates the database with...
asked by 28.11.2016 / 13:45
0
answers

How to transform procedure into DLL?

Good Night. I'm new to the programming area, I got a degree recently despite not having experience. For inexperienced I do not say layman, have only notions of OOP, Database, etc. These days I had the function of doing procedure to do Inserts...
asked by 10.11.2015 / 23:28