可以转化为INT来实现,返回1为真,返回0位假
ALTER proc test
@return1 int output
as
if exists(select * from test1 where id=1)
set @return1=1
else set @return1=0
return @return1GO
ALTER proc test
@return1 int output
as
if exists(select * from test1 where id=1)
set @return1=1
else set @return1=0
return @return1GO
declare @sss int
exec test @sss output
if @sss=1 then .....
else @sss=0 then....