declare @num int,@sqls nvarchar(4000),@code varchar(20)
set @sqls='select @a=count(*) from Customers where colname='''+@code+''''
exec sp_executesql @sqls,N'@a int output',@num output
set @sqls='select @a=count(*) from Customers where colname='''+@code+''''
exec sp_executesql @sqls,N'@a int output',@num output
set @where=''
set @sqls='select @a=count(*) from Customers ' +@where
exec sp_executesql @sqls,N'@a int output',@num output
select @num 放在前面行吗?
set @sqls='select @a=count(*) from Customers where col1='+ 变量
exec sp_executesql @sqls,N'@a int output',@num output
select @num
declare @num int,@sqls nvarchar(4000)
set @sqls='select @a=count(*) from Customers where col1='''+ 变量+''''
exec sp_executesql @sqls,N'@a int output',@num output
select @num