Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Count(*) Rss

Search for any content tagged count(*)

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 1 of 1   
 

Display COUNT(*) but ONLY TOP 100

Let’s say you have a result set with 5000 records but you want to display only 100 of them and in the same time to display the count of ALL records (5000).  Read more...
By Luigi Marinescu 2009/11/20 | Source: SQLServerCentral.com | Category: count(*)
Rating: |  Discuss |   Briefcase | 2,411 reads
   Items 1 to 1 of 1