如何从存储过程调用存储过程 [英] how to call a stored procedure from stored procedure

问题描述

在我的访谈中询问这个问题

解决方案

对于嵌套存储过程 - 尝试确定存储过程 [ ^ ]。

检查此类似帖子从SQL Server中的另一个存储过程调用存储过程 [ ^ ]

< blockquote>我给出了实现目标的几个步骤。



1.创建一个存储过程以添加两个数字

  CREATE  程序 Proc_AdditionTwoNumber 
（
  @ first   int ，
  @ second   int  
）
 
  AS  
 开始 
 声明  @add   int  
  SET  @ add =  @ first  +  @ second  
  SELECT   @ add  
  end  

2.创建另一个存储过程，使用 exec 语句调用第一个存储过程

  CREATE   Procedure  [dbo]。[proc_AddTwoNumber] 
 （
  @ first   int ，
  @ second   int  
）
  AS  
  exec  Proc_AdditionTwoNumber  @ first ， @ second  

3.调用第二个存储过程以获得结果

  exec  proc_AddTwoNumber  12 ， 30  

This queastion asked in my interview

解决方案

For nested stored procedures - try Nesting Stored Procedures[^].

check this similar post Call stored procedure from another stored procedure in SQL Server[^]

I am giving few steps to achieve goal.

1. Create a stored procedure for addition two number

CREATE Procedure Proc_AdditionTwoNumber
(
	@first int,
	@second int
)

AS
Begin
declare @add int
SET @add= @first + @second
SELECT @add
end

2. Create another stored procedure that will call first one using exec statement

CREATE Procedure [dbo].[proc_AddTwoNumber]
(
    @first int,
    @second int
)
AS
exec  Proc_AdditionTwoNumber @first,@second

3. call second stored procedure to get result

exec proc_AddTwoNumber 12,30

这篇关于如何从存储过程调用存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！