declare @Resultt int,@sql nvarchar(500)
set @sql='select @Resultt = count(id) from a where '+@vstr +' =1'
exec sp_executesql @sql,N'@Resultt int output',@Resultt int output
select @Resultt
set @sql='select @Resultt = count(id) from a where '+@vstr +' =1'
exec sp_executesql @sql,N'@Resultt int output',@Resultt int output
select @Resultt
declare @Resultt int,@sql nvarchar(500)
set @sql='select @Resultt = count(id) from a where '+@vstr +' =1'
exec sp_executesql @sql,N'@Resultt int output',@Resultt output
select @Resultt