exec sp_executesql N'SELECT
[Project1].[PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Project1].[SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Project1].[CREATEDATE] AS [CREATEDATE]
FROM ( SELECT
[Extent1].[PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Extent1].[SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Extent1].[CREATEDATE] AS [CREATEDATE]
FROM [dbo].[T_Info_MES_PMIAttribute] AS [Extent1]
) AS [Project1]
ORDER BY [Project1].[CREATEDATE] DESC
OFFSET 30 ROWS FETCH NEXT 30 ROWS ONLY '
exec sp_executesql N'SELECT
[Project1].[PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Project1].[SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Project1].[CREATEDATE] AS [CREATEDATE]
FROM ( SELECT
[Extent1].[PMIATTRIBUTEID] AS [PMIATTRIBUTEID],
[Extent1].[SUPPLIERMATERIAL] AS [SUPPLIERMATERIAL],
[Extent1].[CREATEDATE] AS [CREATEDATE]
FROM [dbo].[T_Info_MES_PMIAttribute] AS [Extent1]
) AS [Project1]
ORDER BY [Project1].[CREATEDATE] DESC
OFFSET 60 ROWS FETCH NEXT 30 ROWS ONLY '
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/132354.html
標籤：C#
上一篇：企業付款到零錢
下一篇：c#使用算術運算子開發簡單計算器