SQL Server Execute Stored Procedure from Another Stored Procedure with Parameters

  MSSQLSERVER   Friday, November 6, 2015   1388 | No Comments Yet!!! | No Download | No Demo | Pawan kumar
 Tags: SQL Server Execute Stored Procedure from Another Stored Procedure with Parameters 


Step 1: Open MS-SQL Server

Step 2: Select a database

Step 3: Create first Stored Procedure with the following codes:-

-- www.sourcecodehub.com ---

 --- First Stored Procedure
CREATE PROCEDURE sp1
@tempid INT,
@tempname varchar(50)
AS
BEGIN
DECLARE @temp1 TABLE (Id INT, Name VARCHAR(50), Location VARCHAR(50))
INSERT INTO @temp1 (Id, Name, Location)
VALUES(1,'raja','india'),
(2,'Rohan','UK'),
(3,'Satu','Nepal')
SELECT * FROM @temp1 WHERE Id=@tempid and Name=@tempname
END

Step 3: Create second Stored Procedure which will call first Stored Prodedure with the following codes:-

-- www.sourcecodehub.com ---
 --- Second Stored Procedure
CREATE PROCEDURE SAMPLE2
@id INT,
@name varchar(50)
AS
BEGIN
-- Calling First Procedure From Second Procedure
EXEC sp1 @tempid=@id, @tempname=@name
END

HOW TO USE:-

EXEC SAMPLE2 @id=1, @name='raja'