Tag:SQL paging stored procedure
-
Implementation of SQL paging stored procedure code
SQL paging stored procedure code, need friends directly to use, use is very simple. The sharing code is as follows USE [SendMessage] GO /****** Object: StoredProcedure [dbo].[pages] Script Date: 07/09/2015 13:46:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[pages] ( @TBNAME nvarchar (100), — the name of the table to be […]
-
Implementation of single conditional paging by SQL Server stored procedure
Not much to say, please see the code: SQLServer Procedure Pagination_basic: ALTER PROCEDURE [qiancheng].[Pagination_basic] ( @Table_name VARCHAR (255), –name of table @Rows_target VARCHAR (1000) = ‘*’, –search rows @Rows_condition VARCHAR (1000) = ”, –the condition to find target (no where) @Rows_order VARCHAR (255) = ”, –the rows to rank @Order_type INT = 0, — *Q*C* […]