declare @Total int
declare @sSql nvarchar(1000)
set @sSql = N'select @Total = count(memberid) from products where memberid=1797049'
execute sp_executesql @sSql,N'@Total int out',@Total out
select @Total as recordCount
declare @sSql nvarchar(1000)
set @sSql = N'select @Total = count(memberid) from products where memberid=1797049'
execute sp_executesql @sSql,N'@Total int out',@Total out
select @Total as recordCount