Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

Shall we write Stored procedure within the another Stored Procedure. Any one can suggest me.
Posted

Futher to "Kankeyan's" solution above bit more detailed

STEP 1 : Create the fist procedure

SQL
create procedure spProcedure1 (@id int)
as
Begin
    Select 'Procudure1 id value=' +STR (@id)

End



STEP 2 : Create the second procedure, Second procedure is calling the first procedure within

SQL
create procedure spProcedure2 (@id2 int)
as
Begin
    Declare @id3 int
    Select 'Procudure2 id value=' +STR (@id2)
    set @id3=@id2*2
    exec spProcedure1 @id3

End



STEP 3: Call the second procedure with a sample paramter

spProcedure2 10



Analyse the output and hope its self explanatory
 
Share this answer
 
YOu can write the two or more stored procedure and call the stored procedure in on stored procedure with necessary inputs

Create Proc Sample
(
Parameters
)
As
BEGIN
some condition
Exec sample 2 <parameter>

END


hope will it helpful
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900