declare @recordCount int
declare @sql nvarchar(max)
set @sql = 'select @count = count(*) from table'
exec sp_executesql @sql,N'@count int out',@recordCount out
select @recordCount
declare @sql nvarchar(max)
set @sql = 'select @count = count(*) from table'
exec sp_executesql @sql,N'@count int out',@recordCount out
select @recordCount