Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,
 
Shall we write Stored procedure within the another Stored Procedure. Any one can suggest me.
Posted 5-Nov-12 21:50pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Futher to "Kankeyan's" solution above bit more detailed
 
STEP 1 : Create the fist procedure
 
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
 
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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
 
END
 

hope will it helpful
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 190
1 Jochen Arndt 155
2 PIEBALDconsult 150
3 Afzaal Ahmad Zeeshan 120
4 DamithSL 115
0 OriginalGriff 5,695
1 DamithSL 4,591
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,190


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100