Getting Top N Rows in SQL2K and SQL2K5 [Non Tech Ppl Plz Excuse]

SQL 2K

declare @topN int

set @topN = 10

set rowcount @topN

select * from [TABLE]

/***************************/

SQL 2K5

declare @topN int

set @topN = 5

select top (@topN) * from [TABLE]

Comments

Popular posts from this blog

Page Life Cycle in ASP.NET

ASP.NET MVC Version History

Auto Refresh .aspx page - ASP.NET

Introduction to ASP.Net MVC

How to Update Dependent Excel Cells Automatically

MVC Request Execution Stages - Life Cycle

Applying Dynamic Themes to WebPage

Abstract Class and An Interface

Differences between a Structure and Class