Stored Procedures (can i use Stored Procedures in Procedures)

Question

0.00/5 (No votes)

See more:

SQL-Server

Hi All,
cn i write procedures in Procedures
please explain
Thanks

Posted 16-Nov-13 16:28pm

Amarender1479

Add a Solution

Comments

Maciej Los 17-Nov-13 11:05am

I'm not sure what you mean...
Do you want to create new stored procedure inside another one?

2 solutions

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)

Mehdi Gholam · Answer 1 · 2013-11-16T20:04:00

Solution 1

Read the following : http://technet.microsoft.com/en-us/library/ms189915.aspx[^]

If you mean create multiple stored procedures inside a stored procedure (e.g. modules), then no you can't.

Posted 16-Nov-13 20:04pm

Mehdi Gholam

Comments

Maciej Los 17-Nov-13 11:06am

+5!

Mehdi Gholam 17-Nov-13 13:34pm

Thanks Maciej!

CHill60 · Answer 2 · 2013-11-17T04:59:00

Solution 2

Further to Mehdi Gholam's answer, if it is the title of your post that indicates your question (rather than the text of the question itself) then yes, you can "use stored procedures in procedures"

Just call them one after the other e.g.

SQL

exec dbo.StoredProc1
exec dbo.StoredProc2
-- etc

Note that SQL Server is not asynchronous so StoredProc2 will not start until StoredProc1 has finished

Posted 17-Nov-13 4:59am

CHill60

Comments

Maciej Los 17-Nov-13 11:06am

+5!

Mehdi Gholam 17-Nov-13 13:35pm

5'ed

CHill60 17-Nov-13 15:59pm

Thank you! Wasn't trying to contradict you by the way, just read the question in a different way. Also my 5 to you to directing OP to a good resource

Mehdi Gholam 18-Nov-13 1:49am

No worries, good to have different views.