var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Like LIMIT for MySql but for MSSQL
I am looking for a function in MSSQL that performs similar to the LIMIT function in MySQL. Here is the LIMIT function's definition:
I am aware of TOP and SET ROWCOUNT functions in MSSQL but neither provide the Offset functionality.
The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants.
With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):
mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15
Any help would be appreciated,
Nope...perhaps in SQL Server 2005...
This is the Best I've found. Say Hi to Jeff for me