获取动态SQL的返回值
declare @return bit
declare @sql nvarchar(1000)
set @sql='if(''abc''=''abc'') set @return=1 else set @return=0'
Exec sp_executesql @sql, N'@return int output', @return output
select @return
declare @sql nvarchar(1000)
set @sql='if(''abc''=''abc'') set @return=1 else set @return=0'
Exec sp_executesql @sql, N'@return int output', @return output
select @return