xugangjava的专栏

转载请注明出处http://blog.csdn.net/xugangjava SET @rowsPerPage = 10      SET @pageNum = 3            With SQLPaging      As      (      Select Top(@rowsPerPage * @pageNum) ROW_NUMBER() OVER (O

记下来 以后要用直接过来copy了 http://blog.csdn.net/xugangjava CREATE DEFINER=`root`@`localhost` PROCEDURE `pageSplit`(   fromWhere varchar(50),   selectColum varchar(500),   orderBy varchar(100),   co

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= ALTE

全部查询到临时表中 然后 批量删除 ALTER PROCEDURE [dbo].[proc_DocDelFolder] @FolderId INT AS BEGIN SET NOCOUNT OFF DECLARE @i INT SET @i = 0 INSERT INTO #FIDS (