--参考以下这个 /* create table a (id int)insert into a select 1 select * from a id ----------- 1(所影响的行数为 1 行) */ declare @s nvarchar(1000) set @s =N'select @i =count(1) from a ' declare @i int exec sp_executesql @s ,N'@i int OUTPUT',@i output if @i >0 print 1 else print 0--1
我这样也有语法错误
/*
create table a (id int)insert into a select 1 select * from a id
-----------
1(所影响的行数为 1 行)
*/
declare @s nvarchar(1000)
set @s =N'select @i =count(1) from a '
declare @i int
exec sp_executesql @s ,N'@i int OUTPUT',@i output
if @i >0
print 1
else
print 0--1