over 9 years ago
Call a procedure with in procedure in SQL server :-
While working in sql Some times you need to Calling one stored procedure within another stored procedure. So you can implement this using below sample code:---
- //Store Procedure 1
- CREATE PROCEDURE uspTest1
- AS
- BEGIN
- SELECT * FROM Student
- END
- //Store Procedure 2
- CREATE PROCEDURE uspTest2
- AS
- BEGIN
- // To call the Procedure uspTest1 in this procedure
- // Its return that Procedure output.
- exec uspTest1
- END
//Store Procedure 1
CREATE PROCEDURE uspTest1
AS
BEGIN
SELECT * FROM Student
END
//Store Procedure 2
CREATE PROCEDURE uspTest2
AS
BEGIN
// To call the Procedure uspTest1 in this procedure
// Its return that Procedure output.
exec uspTest1
END
0 Comment(s)