SQL SERVER 2012 T-SQL 新增对象 SEQUENCE 续
现在， 再来看一个应用。ALTER SEQUENCE DBO.SQ1
RESTART WITH 1
INCREMENT BY 1
NO MAXVALUE
NO CYCLE
GO
TRUNCATE TABLE T2
GO
TRUNCATE TABLE T3
GO
CREATE TABLE T2
(ID INTEGER DEFAULT(NEXT VALUE FOR SQ1),
NAME VARCHAR(20)
)
CREATE TABLE T3
(ID INTEGER DEFAULT(NEXT VALUE FOR SQ1),
NAME VARCHAR(20)
)
INSERT INTO T2(NAME) VALUES('A')
INSERT INTO T3(NAME) VALUES('A')
SELECT * FROM T2
GO
SELECT * FROM T3
GO
页:
[1]