SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag TOP 100 Rss

Search for any content tagged top 100

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts 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,429 reads
   Items 1 to 1 of 1