17,377
社区成员
发帖
与我相关
我的任务
分享
Select identity(int, 1, 1) as id, name, year into #t from tbl order by name, year
------1.建立 sequence
CREATE SEQUENCE my_sequence
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
---------2、建立临时表
CREATE TABLE T AS
SELECT MY_SEQUENCE.NEXTVAL AS ID,
NAME,
YEAR
FROM TBL
ORDER BY NAME,
YEAR