一个存储过程调用多个存储过程

Question

如何在一个存储过程中调用多个存储过程，假如输入一个条件if，去执行一个存储过程，另一个if执行另一个存储过程，求教

Answer 1

和普通的调用没区别

if 条件 exec 存储过程1 else exec 存储过程2

Answer 2

Hi manorsheep,

写了一个最简单的，你参考一下：

create procedure A
as
begin 
print 'hello A'
end

create procedure B
as 
begin
print 'hello B'
end

create procedure if_else
(@a int)
as
begin
if (@a = 1) 
	begin 
		exec dbo.A
	end
else
	begin
		exec dbo.B
	end
end

exec dbo.if_else @a = 2

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].