How do I get the rowcount value of table variables?

Question

How do I get the value of a row in a variable table?

Answer 1

If you mean SQL Server table variables, it's just like a regular table:

DECLARE @Foo TABLE ( foo int ); insert into @Foo values (1); insert into @Foo values (1); insert into @Foo values (1); insert into @Foo values (1); select COUNT(*) from @Foo; 

Answer 2

 SELECT COUNT(*) FROM TABLE_NAME; 

Answer 3

 SELECT COUNT(*) OVER ( ) AS 'RowCount' FROM @yourTableVariable 

works great for table variables!