Skip to content

Instantly share code, notes, and snippets.

@bjartwolf

bjartwolf/eftypeprovider.sql

Created June 26, 2015 19:46
Show Gist options
  • Save bjartwolf/7944a669949e9128f56f to your computer and use it in GitHub Desktop.
Save bjartwolf/7944a669949e9128f56f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
eftypeprovider.sql
SELECT TOP (1000)
[Extent1].[FirstName] AS [FirstName]
FROM ( SELECT [Extent1].[Id] AS [Id], [Extent1].[FirstName] AS [FirstName], row_number() OVER (ORDER BY [Extent1].[Id] ASC) AS [row_number]
FROM [dbo].[Profile] AS [Extent1]
) AS [Extent1]
WHERE [Extent1].[row_number] > 200001
ORDER BY [Extent1].[Id] ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment