摘要： View Code 2 GO 3 /****** Object: StoredProcedure [dbo].[UP_General_GetPage] Script Date: 03/17/2011 11:16:59 ******/ 4 SET ANSI_NULLS OFF 5 GO 6 SET QUOTED_IDENTIFIER OFF 7 GO 8 9 10 -- =============================================11 -- 主 题：通用分页存储过程12 -- 功 能：对数据按照 不同的列，不同页尺寸分页13 -... 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_General_GetRowCount] Script Date: 03/17/2011 11:17:19 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 ALTER PROCEDURE [dbo].[UP_General_GetRowCount] 8 @strTable nvarchar(255), -- 表名 9 @strField nvarchar(1000) = '*' 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_General_GetOrderPage] Script Date: 03/17/2011 11:16:42 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 ALTER PROCEDURE [dbo].[UP_General_GetOrderPage] 8 @tblName nvarchar(255), -- 表名 9 @st... 阅读全文

摘要： View Code 1 GO 2 /****** Object: StoredProcedure [dbo].[UP_Common_GetPage] Script Date: 03/17/2011 11:16:21 ******/ 3 SET ANSI_NULLS ON 4 GO 5 SET QUOTED_IDENTIFIER ON 6 GO 7 -- ============================================= 8 -- Author: 9 -- Create date: 2-2010 -- Description: 分页存储过程11 -- ===... 阅读全文