KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am writing a wpf destop application, and would like to use SQL Server CE as a backend. I'm trying to come up with a good way to do efficient data paging. In SQL Server Express, I can do something like this: Select ID, FirstName, LastName From (SELECT ROW_NUMBER() OVER (ORDER BY ID) AS Row, ID, FirstName, LastName From TestTable ) WHERE Row > 1 AND Row <= 10 Is there anything comparable in SQL Server CE? I'm not completely sure what is and is not supported. I want to only return 10 rows at a time from the database, and not have to pull back all the data and then filter it down to display to the user, since that is much slower. Thanks.
Tags (comma-separated)
Save Edits
Cancel