Executing SQL Stored Procedure from Another Stored Procedure

In this blog, I explain how to execute a stored procedure within another stored procedure in SQL with parameters.

In large database applications, it is common to call one stored procedure from another stored procedure. In this blog, I will explain how to execute a stored procedure within another stored procedure in SQL Server.

Let's start with creating a stored procedure.

Here's the query for creating our first procedure:.

create procedure Sp_insert
(
@ID int,
@TempName varchar(max)
)
as
begin
Declare @SampleTable Table(id int, Name varchar(max))
Insert into @SampleTable(id,Name)values(@ID,@TempName)
select*from @SampleTable
end

Here is my second stored procedure. 

create procedure Sp_Call
(
@SID int,
@Name varchar(max)
)
as
begin
exec Sp_insert @ID=@SID,@TempName=@Name
end
From t

Your stored procedure will be based on your database. So, create two stored procedures where data of the second stored procedure can be used in the first stored procedure. If you're new to stored procedures, please read, Learn Everything About Stored Procedures In SQL Server. 

 

In the above query, you may notice that we are calling the first stored procedure Sp_insert  and passing the parameter @ID and @TempName to it.

Now execute the second procedure using the following query. It will call the first procedure and return the result. 

Exec Sp_Call @SID=1,@Name='Arun'

The result:

 

   

Next: Creating and Using Stored Procedure In SQL Server