By Daniele Salatti
Expert Author
Article Date: 2008-09-16
I don't like MSSQL, I prefer MySQL, but many times I have to deal with it at work. Lots of developers, including me and my co-worker Enrico, hate that Microsoft SQL hasn't something like MySQL's LIMIT(from, to). With some new T-SQL commands in Miscrosoft SQL Server 2005 there is a not-so-simple solution.
- DECLARE @rowsperpage INT
-
- DECLARE @start INT
-
- SET @start = 100
- SET @rowsperpage = 10
-
- SELECT * FROM
- (
- SELECT row_number() OVER (ORDER BY column) AS rownum, column2, column3, .... columnX
- FROM table) AS S
- WHERE S.rownum BETWEEN (@start+1) AND (@start + @rowsperpage)
What about performances? Take a look at the images below!
Comments
