1、
调用:(临时表、调用存储过程)
create table #5(
ID int,
ProjectName varchar(200),
ContractNumber varchar(100),
)
insert #5 EXEC [USP_Product_GetPaged2] '','ID DESC',0,10
select * from #5
存储过程:
print @sql :打印消息可在SQL结果窗口-消息里查看:
USE [ZKWebForm121920170831(删减版)]
GO
/****** Object: StoredProcedure [dbo].[USP_Product_GetPaged2] Script Date: 09/28/2017 11:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery2.sql|7|0|C:\Users\JM\AppData\Local\Temp\~vs60C9.sql
ALTER PROCEDURE [dbo].[USP_Product_GetPaged2]
@WhereClause VARCHAR (2000),
@OrderBy VARCHAR (2000),
@PageIndex INT,
@PageSize INT
AS
BEGIN
DECLARE @PageLowerBo