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?

I believe you have asked the same question before: http://stackoverflow.com/questions/5199412/number-of-rows-sql-server — reggie, May 05 '11 at 19:08
Well, here I am asking how to assign that number to a variable, other question was how to do that efficiently — edgarmtze, May 05 '11 at 19:09
@darkcminor, I agree with @reggie, the previous question already assigned the result to a variable. — Brent D, May 09 '11 at 19:57

score 18 · Accepted Answer · edited May 05 '11 at 20:30

18

Something like the following should do the trick:

Declare @VariableName int

Select @VariableName=count(1) from TableName

edited May 05 '11 at 20:30

marc_s

answered May 05 '11 at 19:06

Brent D

2

If you post code, XML or data samples, **please** highlight those lines in the text editor and click on the "code samples" button ( `{ }` ) on the editor toolbar to nicely format and syntax highlight it! – marc_s May 05 '11 at 20:30
3

@marc_s Thanks, still trying to figure out the simple things in life! :) – Brent D May 09 '11 at 19:53

score 0 · Answer 2 · answered May 05 '11 at 19:06

0

SELECT COUNT(*) FROM Table

For more details, please provide more detail.

answered May 05 '11 at 19:06

SLaks

2 Answers2