eg:
create procedure test ...
As
...
if ...
return 0
else
return 1
go调用:
declare @a int
exec @a = test
select @a
create procedure test ...
As
...
if ...
return 0
else
return 1
go调用:
declare @a int
exec @a = test
select @a
create procedure test @aa int output
as
...
if ...
set @aa = 0
else
set @aa = 1
go调用
declare @i int
exec test @i output
select @i