Running multiple query statements in Stored Procedure

Question

0.00/5 (No votes)

See more:

Hi Friends,,,,

I want to run multiple query statements(INSERT,UPDATE,DELETE) in a Single Stored Procedure.

But the Delete query is not working.

Any suggestions...

Posted 19-May-13 20:19pm

PRAKASH_N

Add a Solution

4 solutions

Solution 3

if you want single sp for crud operaton then
you should define @Task variable and use if conditions like below pass value to sp for task also with other parameters...

SQL

if @Task = 1 
Begin
//insert
return
end 
elseif @Task = 2 
Begin
//update
return
end
elseif @Task = 3
Begin
//Delete
return
end

Happy Coding!
:)

Posted 19-May-13 20:51pm

Aarti Meswania

Solution 1

You can put in as many queries as you like in a stored procedure.
Check that you are passing the right query parameters to delete the row and that the row exists in the table.

Posted 19-May-13 20:20pm

Abhinav S

Solution 4

check this link

Overview of SQL Server Stored Procedure[^]

Posted 19-May-13 20:53pm

josh-jw

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Damian S_ · Accepted Answer · 2013-05-19T20:34:00

Solution 2

Without seeing your queries or table structures, it's difficult to give you a definitive answer... in addition to what Abhinav S says, it might also be that the delete query is failing due to key constraints (primary key/foreign key) on the row you are trying to delete.

Posted 19-May-13 20:34pm

_Damian S_

Comments

PRAKASH_N 20-May-13 3:20am

my query is

alter procedure RunIssue
(
@id int,
@Cname varchar(20)
)
as
begin

update EmpTab set empName=@Cname where id=@id

delete CustDetail where id=@id

insert into tmpTable(id,cname) values(@id,@Cname)

delete SubIssue

end

_Damian S_ 20-May-13 19:58pm

Okay, so the question is, what's in CustDetail table for the id you are looking to delete... for instance, do they have a linked record in CustOrders or CustAddress (examples - your table names will vary)?