I have a stored procedure that checks if a record exist and if true then should update else it should insert. But for some weird reason the update does not work and it inserts a record. As a result I have now accumulated duplicate records …
CREATE OR REPLACE PROCEDURE seleccionar (
registros OUT SYS_REFCURSOR,
codigo NUMBER
) AS
BEGIN
OPEN registros FOR SELECT
nombre_producto,
precio_producto,
…
First of all i excuse me if this question looks very simple for you. Since, i have no idea how to write sp i am posting this question:
Basically i want to write store procedure for and my use case is:
select distinct id from table
select…
I am trying to call a stored procedure when I click a button in a winform using c#. The stored procedure has a insert statement where the value boardID = @newGameID.
newGameID references a value that is passed in in my c# code. As a test I…
I am trying to call a stored procedure when I click a button in a winform using c#. The stored procedure has a insert statement where the value boardID = @newGameID.
newGameID references a value that is passed in in my c# code. As a test I…
As part of my development activity in project I need to update or insert the output table. I am trying to pass a DF as table valued parameter in store procedure. By using SP I want to achieve this. Could someone please help me here.
I have…
I need to return results from a mssql stored proc on the basis of datetime2. There’s a employee table with punch in and punch out time. I need to return results all the data from an employee on the basis of start time and end time. My quer…
I am trying to run a copy command inside a stored procedure.
This copy command copies from aws s3 to a table in aws redshift
This is the copy command
copy schema1_ghsheet.ghseet_temp
from
””s3://root2/rawfiles/””
iam_role ””arn:aws:i…
i have column in one table with string value than string value splited with ‘,’
my table is like this:
id strColumn
1 abc,def,egh,asa,plok
I want the character string to be separated using the split function when placed in …
I am using SQL Server 2014. I have some user defined tables like Customer, PurchaseOrder, User, and so on. I am using those tables inside many stored procedures. In some cases, those stored procedures are almost 1000/1500 lines long.
Now …
I am trying to create a row in an SQL table by calling a stored procedure from C# code. The table has over 50 columns. I could create 50 parameters in the stored procedure like so:
@param_1 nvarchar(32);
@param_2 nvarchar(32);
@param_3 nva…
I know this is a kind of stupid question. But just want to know any ideas is available.
This images shows my table and Po_Settl coloumn type is bit and Settled_ type is int.
So when user cancel the record I want to fill this again to the N…
Used MariaDB Version: 10.2.36
I am trying to create procedure with multiple parameters and setting some variables inside it but I am getting this error
#1064 – You have an error in your SQL syntax; check the manual that corresponds to you…
UPDATED Ok, here is the problem. I keep getting a invalid use of group function, I do not understand why. I am calling a stored procedure and that calls another stored procedure. I am trying to use a radio Button to send information to the…
I want to do something like this:
create or replace procedure get_deleted_rows(result_set OUT SYS_REFCURSOR) is
begin
delete from table1
where start_date >= sysdate – 30 and start_date <= sysdate
returning * bulk collect into resu…
I would like to know the real-time basic process between server side and SQL server. I’m having only basic knowledge about sps in SQL server. E.g data send from ui through server, in SQL server through sps we’re doing some calculations and…
I try to find a reason why a stored procedure stopped working after updating my model..edmx file.
Or could it be related to Nuget packages?
Nuget stopped downloading packages on the network, but I solved this problem,
by downloading and pl…
We have a Firebird 2.5 stored procedure that carries out multiple inserts & updates, and is called as a result of website actions, so can be called simultaneously.
We need to stop it running more than once at the same time, and I’m won…
I want to insert student data in the database using c# and SQL server stored procedure.
Sample to enter Student data:
Name: ABC
Class: First
Roll_No: 1
Subject1: English
Total_marks: 20
Obtained_marks: 10
S…