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
0 Comment(s)