更新 Sql排序

最新推荐文章于 2025-01-20 19:20:54 发布

转载最新推荐文章于 2025-01-20 19:20:54 发布 · 244 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/merseyalma/archive/2011/03/21/1990647.html

文章标签：

#数据库

CREATE TABLE [dbo].[CustomerTrack](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CustomerID] [uniqueidentifier] NULL,
[Channel] [int] NULL,
[OrderIndex] [int] NULL,
[Value] [nvarchar](50) NULL,
CONSTRAINT [PK_CustomerTrack] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

---------------

上表增删改之后，下述脚本更新orderindex

with r_SomeTable
as
(
select *

, row_number() over(partition by IDCol order by ValueCol) as rnk
from SomeTable
)
update r_SomeTable
set RANKCol = rnk

转载于:https://www.cnblogs.com/merseyalma/archive/2011/03/21/1990647.html