?件工程
-
编辑 删除
分頁procedure (SQL Server)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Paging_Cursor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[Paging_Cursor]GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO[@more@]CREATE PROCEDURE Paging_Cursor (@Tables varchar(1000),@PK varchar(100),@Sort varchar(200) = NULL,@PageNumber int = 1,@PageSize int = 10,@Fields varchar(1000) = '*',@Filter varchar(1000) = NULL,@Group varchar(1000) = NULL)AS/* exec Paging_Cursor 'SURVEYINFOTMP','FSFID',null,2 *
