Multiple Queries in a Stored Procedure SQL Server 2008

Question

0.00/5 (No votes)

See more:

Hi to all. Is there any way to write an Update query and an Insert query in a single Stored Procedure? If So,please tell me how.

Thanks in Advance.

Posted 8-Jan-13 21:51pm

Jagan911

Add a Solution

Comments

josh-jw 9-Jan-13 3:55am

CREATE PROCEDURE PROCEDURE_NAME
AS
BEGIN
//your insert query
//your update query
end

Jagan911 15-Jan-13 0:15am

Hi Josh-JW, Thanks for your reply.It helped me to resolve my requirement.

1 solution

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)

pranathis012 · Accepted Answer · 2013-01-08T21:57:00

Solution 1

U can Write.

follow this sample SP

SQL

CREATE PROCEDURE PROCEDURE_NAME
(
   @Trans_Type VARCHAR(100),
   --whatever u want  u add parameters on here
)
AS
BEGIN
   IF @Trans_Type='INSERT'
   BEGIN
     --UR INSERT QUERY
   END
   ELSE IF @Trans_Type='UPDATE'
   BEGIN
      --UR UPDATE QUERY
   END
END

I think this might help you...

Posted 8-Jan-13 21:57pm

pranathis012

Comments

Jagan911 15-Jan-13 0:16am

Hello PranathiS012, thanks for responding to my question.Your answer helped me a lot.