Assign a variable the number of rows a table has in SQL Server

Question

How would you assign a variable the total number of rows in which a table has a SQL Server value?

Answer 1

Something like the following should do the trick:

 Declare @VariableName int Select @VariableName=count(1) from TableName 

Answer 2

SELECT COUNT(*) FROM Table

For more information, please provide more information.