declare @SQLStr Nvarchar (4000),@re bit --注意变量定义 select @SQLStr = 'set @re=case when exists(select * from Teacher where Username = ' + '''' + @usr + ''') then 1 else 0 end' exec sp_executesql @SQLStr,N'@re bit out',@re out if @re=1 ....貌似当时邹建大大是类似这样解决的
declare @SQLStr Nvarchar (4000),@re bit --注意变量定义
select @SQLStr = 'set @re=case when exists(select * from Teacher where Username = ' + '''' + @usr + ''') then 1 else 0 end'
exec sp_executesql @SQLStr,N'@re bit out',@re out
if @re=1
....貌似当时邹建大大是类似这样解决的