Most voted "stored-procedures" questions
Stored Procedure is a set of SQL commands that stores repetitive tasks and accepts input parameters for the task to be performed according to individual needs. This tag should be used when the problem/doubt relates to the construction, performance and/or call stored procedures.
Learn more…169 questions
Sort by count of
-
0
votes1
answer65
viewsProblem with dynamic delete procedure in mysql
I’ve been doing some research on the Internet but I haven’t had much success. I am mounting a precedent to delete values dynamically relative to the dependencies of a given table but I can pass only…
-
0
votes0
answers38
viewsHow can I clone a record from a stored table using Procedure and picking up the fields dynamically?
I have the need to clone a record into a table but picking up the fields the way they are, the reason is that someone can insert or remove some column, so I don’t know which columns I have in the…
-
0
votes1
answer30
viewsHow do I get back the id of the new record created in a table using cursor and Procedure in SQL Server?
I’m trying to make my previous run and return the registration ID that has just been created, as I don’t have much knowledge of cursors and procedures I don’t know where I am failing. When I run the…
-
0
votes1
answer56
viewsStored procedures in mysql do not validate type?
I have a stored file in my mysql that is in simple, it selects a table and filters by an id. Follow the store: create definer procedure fn_get_client_data(IN _email varchar(100), IN _id_loja int)…
-
0
votes0
answers34
viewsProcedure de Update oracle
Good morning! I’m still a layman at BD and I’ve been catching a little bit. I would like, please, to know if you could help me with a given problem. My scenario is as follows. I have two screens, a…
-
0
votes0
answers29
viewsProblem with validation process
I am creating a precedent to validate whether the field discount (%) receives a percentage less than zero (negative value) or greater than 100%. But when executing appears an error that I am not…
-
0
votes0
answers12
viewsError in the execution of the PROCEDURE
Health and Peace for all, This is about the following: Has a tb_register, to study how to populate the table with dates (created with Mysql), with the fields: cliente_id Primária int(11) data_inicio…
stored-proceduresasked 3 years, 10 months ago Carlos Teixeira 5 -
0
votes0
answers20
viewsReceive a number through a Stored Process c#
I have an object that has properties of various types and one of them is a List <int? >, however when executing a precedent it returns me only one number, does it work if I remove the list and…
-
0
votes1
answer74
viewsSummarizing birthday girls by month (SQL)
I’m trying to count the number of birthday clients per month in my database, but I can only make it display the months that have birthday kids, for example: But I need him to show the months that…
-
-1
votes1
answer1899
viewsCall Procedure inside another
I need to create a precedent enviar_email_servidores call in another pr_envia_email. The term to be called (pr_envia_email) has the function of sending email, and I need the message sent to this…
-
-1
votes1
answer43
viewsConversion of Procedures
Does anyone know or know an easy but easy way to migrate stored-procedures from SQL-Server to Oracle.
-
-1
votes1
answer39
viewsProcedures Mysql
Hi, I’m new to procedures and I have a question I couldn’t find on the internet. I need to create a procedure to include 2 tables: "User", "Supplier". The provider has a user FK, that is, in this…
-
-1
votes1
answer26
viewsInsert random numbers through Precedent
I am trying to insert some random record into a table but am encountering some errors. I created a test table; `create table teste_p(Handle int, name varchar(20)); I need to insert something like:…
-
-1
votes1
answer963
viewsCreate stored Procedure with Mysql
I do bank EAD and have very little material to help me do my activities. I am with this question to resolve, if anyone can help me or help me with some way of study material I am very grateful.…
-
-1
votes2
answers501
viewsIs it possible to run 2 queries at the same time in Mysql? Stored Procedure
I need to create a stored procedure to update the salaries of employees who earn less than 1000 and give a 10% increase. Other employees (who earn over 1000) will have 15% reduction. I did the…
-
-1
votes1
answer176
viewsInserting a PROCEDURE in query() in PHP
Guys, I’ve been trying for a while to integrate a project together with PHP, but when calling it, PHP keeps showing errors: Overview: $database = null; function Conecta($server, $user, $port, $bd){…
-
-1
votes1
answer88
viewsHow to get a Procedure return using ODBC in PHP?
I am trying to communicate PHP with the Caché database of Intersystems, but I will need to use ODBC to communicate. My doubt is how I can get PHP to return Procedure, in the case of a String, I’m…
-
-1
votes0
answers23
viewsHow to group specific data
I made a precedent in which I am trying to group the items with the same id_request, but the answer I get at the time of running is, each separate product, even though it still has the same id.…
-
-3
votes1
answer23
viewsPROCEDURE ERROR PERFORMS ONLY ONCE AFTER GOING MYSQL CONDITION
I have a problem in my past, the scenario is that I have null and not null values that are primary key fields, I am making a Datawarehouse. As all these values need to be calculated, when running…