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

Question

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

Answer 1

Something like the following should do the trick:

Declare @VariableName int

Select @VariableName=count(1) from TableName