Question

sql server sql语句创建序列怎么写？

有一道题，给出一个表，有一个cust_jd属性，数据类型为number(9)
要求为该表的cust_id建立一个序列cust_id_seq
表名为cust_info
SQL语句里面不是有个sequence（序列）关键字吗？想知道如何创建它

Answer 1

增加属性应该是这样写的吧
ALTER TABLE cust_id ADD cust_id_seq number(9) identity(1,1)

如果你要搞sequence
CREATE SEQUENCE cust_id_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 999999999
NOCYCLE;

增加的时候用cust_id_seq.nextval

Answer 2

你看看解决了不
alter table cust_info add sequence int
insert into cust_info (sequence)
select row_number() over(order by cust_id) as cust_id_seq from cust_info