Skip to content

Instantly share code, notes, and snippets.

@bjartwolf

bjartwolf/sqltypeprovider.sql

Created June 26, 2015 19:48
Show Gist options
  • Save bjartwolf/25ccffcf22c9e90f440f to your computer and use it in GitHub Desktop.
Save bjartwolf/25ccffcf22c9e90f440f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqltypeprovider.sql
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY [t0].[FirstName]) AS [ROW_NUMBER], [t0].[FirstName]
FROM [dbo].[Profile] AS [t0]
) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN @p0 + 1 AND @p0 + @p1
ORDER BY [t1].[ROW_NUMBER]',N'@p0 int,@p1 int',@p0=200000,@p1=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment