declare @tableset @table = 'tbl'declare @i int , @sql nvarchar(2000)select @sql = 'select @i = count(*) from ' + @tableexec sp_Executesql @sql , N'@i int out',@i outputprint @i