作者:乃君敏睿64 | 来源:互联网 | 2018-07-10 10:48
--RegionParametersDECLARE@p0Int20DECLARE@p1Int10--EndRegionSELECT[t1].[CustomerID],[t1].[CompanyName],[t1].[ContactName],[t1].[ContactTitle],[t1].[Address],[t1].[City],[t1].[Region],[t1].[PostalCode],[t1].[Country],
-- Region ParametersDECLARE @p0 Int = 20 DECLARE @p1 Int = 10 -- EndRegionSELECT [t1].[CustomerID], [t1].[CompanyName], [t1].[ContactName], [t1].[ContactTitle], [t1].[Address], [t1].[City], [t1].[Region], [t1].[PostalCode], [t1].[Country],
-- Region Parameters
DECLARE @p0 Int = 20
DECLARE @p1 Int = 10
-- EndRegion
SELECT [t1].[CustomerID], [t1].[CompanyName], [t1].[ContactName], [t1].[ContactTitle], [t1].[Address], [t1].[City], [t1].[Region], [t1].[PostalCode], [t1].[Country], [t1].[Phone], [t1].[Fax]
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY [t0].[CustomerID], [t0].[CompanyName], [t0].[ContactName], [t0].[ContactTitle], [t0].[Address], [t0].[City], [t0].[Region], [t0].[PostalCode], [t0].[Country], [t0].[Phone], [t0].[Fax]) AS [ROW_NUMBER], [t0].[CustomerID], [t0].[CompanyName], [t0].[ContactName], [t0].[ContactTitle], [t0].[Address], [t0].[City], [t0].[Region], [t0].[PostalCode], [t0].[Country], [t0].[Phone], [t0].[Fax]
FROM [Customers] AS [t0]
) AS [t1]
WHERE [t1].[ROW_NUMBER] BETWEEN @p0 + 1 AND @p0 + @p1
ORDER BY [t1].[ROW_NUMBER]
,