Connecting Tech Pros Worldwide Forums | Help | Site Map

Does SQL Server support a row count function?

Newbie
 
Join Date: Aug 2008
Posts: 2
#1: Aug 6 '08
My apologies if this has been answered previously, there are too many pages to search every topic covered. [Am I missing a internal search tool that I might have used?]

My interest is in a row count of the result set after a sql query. In Sybase it was ROWCNT gave a quick count. In the reference I am using predated the release of the 2000 version; the then current version and to be released version did not support this function. Has it been added subsequently?

TIA, TxtEdMacs

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Aug 6 '08

re: Does SQL Server support a row count function?


Are you looking for this ?

-- CK
Newbie
 
Join Date: Aug 2008
Posts: 2
#3: Aug 6 '08

re: Does SQL Server support a row count function?


Yes that is exactly what I was seeking. Thank you!
Reply