SQL paging

How to fetch from a table row number 10 to 20:

SELECT [t1].*
FROM (
   SELECT ROW_NUMBER() OVER (
   ORDER BY [t0].<primarykey>) AS [ROW_NUMBER],  [t0].*
   FROM [dbo].[<tablename>] AS [t0]
) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN <fromrow> AND <torow>
ORDER BY [t1].[ROW_NUMBER]

Silverlight Developer runtime not installed

 

Download the following.

http://go.microsoft.com/fwlink/?LinkID=188039

The "Silverlight managed debugging package" is part of the developer runtime, not the SDK or Tools.  Make sure you have the latest version of the developer runtime installed (available at http://go.microsoft.com/fwlink/?LinkID=188039)