How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?

by

SQL Server 2012 and above have added this syntax:

SELECT *
FROM Sales.SalesOrderHeader 
ORDER BY OrderDate
OFFSET (@Skip) ROWS FETCH NEXT (@Take) ROWS ONLY

More Related Contents:

  1. Using “GO” within a transaction
  2. Does End Using close an open SQL Connection
  3. Does this code prevent SQL injection?
  4. How can you name the Dataset’s Tables you return in a stored proc?
  5. Using a variable for table name in ‘From’ clause in SQL Server 2008
  6. How do you effectively model inheritance in a database?
  7. Like Operator in Entity Framework?
  8. Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
  9. store image in database or in a system file? [closed]
  10. SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
  11. What is the correct SQL type to store a .Net Timespan with values > 24:00:00?
  12. How can I solve a connection pool problem between ASP.NET and SQL Server?
  13. Fastest way to perform nested bulk inserts with scope_identity() usage?
  14. Login failed for user ‘DOMAIN\MACHINENAME$’
  15. How to find foreign key dependencies in SQL Server?
  16. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  17. Update primary key value using entity framework
  18. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  19. Parameterized Queries with LIKE and IN conditions
  20. SqlDateTime.MinValue != DateTime.MinValue, why?
  21. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  22. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  23. Procedure expects parameter which was not supplied
  24. TSQL md5 hash different to C# .NET md5
  25. How can I create database tables from XSD files?
  26. How can I avoid SQL injection attacks in my ASP.NET application?
  27. How to I serialize a large graph of .NET object into a SQL Server BLOB without creating a large buffer?
  28. Unable to load DLL ‘SqlServerSpatial.dll’
  29. .NET, the SqlConnection object, and multi-threading
  30. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)

Leave a Comment