select * from dbo.tab_name
alter proc testvalue
as
begin
declare @output int
declare @strSql nvarchar(200)
set @strSql=N'select @output=count(ID) from tab_name'
exec sp_executesql @strSql,N'@output int output',@output output
select @output
end
go
exec testvalue