declare @strSql nvarchar(max)
declare @Count int
set @strSql='select @a= count(*) from TB_FillQ '
exec sp_executesql @strSql ,N'@a int output',@Count output
select @Count
declare @Count int
set @strSql='select @a= count(*) from TB_FillQ '
exec sp_executesql @strSql ,N'@a int output',@Count output
select @Count