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

How would you assign a variable the tota开发者_如何学Gol number of rows a table has in SQL Server?

---

Something like the following should do the trick:

Declare @VariableName int

Select @VariableName=count(1) from TableName

---

SELECT COUNT(*) FROM Table

For more details, please provide more detail.