SQL SERVER 2012 T-SQL 新增对象 SEQUENCE 续

现在， 再来看一个应用。

ALTER SEQUENCE DBO.SQ1RESTART WITH 1INCREMENT BY 1NO MAXVALUENO CYCLEGOTRUNCATE TABLE T2GOTRUNCATE TABLE T3GOCREATE 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 T2GOSELECT * FROM T3GO