Save Procedure Select a Variable

Question

How can I calculate the result of a table and go into a stored procedure variable?

DECLARE @totalrecs varchar select count(id) from table1 

I need a count entry in the variable totalrecs.

Answer 1

like this

 --will not count NULLS select @totalrecs= count(id) from table1 --will count NULLS select @totalrecs= count(*) from table1 

Answer 2

 DECLARE @totalCount Int Select @totalCount = count(*) From table1 Exec sp_DoSomething @Var = @totalCount 

Answer 3

 select @totalrecs= count(id) from table1