摘要： 做一下备忘MOVEUP:set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[Proc_MoveUp] @id intASBEGIN declare @preSort int;--上一条记录的排序值 declare @preid int; --上一条记录的id值 declare @curSort int;--当前记录的排序值 with TB As (select top 1000 *,row_number() over(order by Sort desc,id desc) as ro... 阅读全文