5 ms·
Is it correct that SQL Server does not support IDENTITY(slide 29)? IDENTITY property is supported from as far as I can remember: https://docs.microsoft.com/en-
by some_user54 8y ago
Is it correct that SQL Server does not support IDENTITY(slide 29)?
IDENTITY property is supported from as far as I can remember:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/t-sql/statements/create...
Second approach is DEFAULT with sequence.
CREATE SEQUENCE seq;
CREATE TABLE tab(i INT DEFAULT NEXT VALUE FOR seq, b VARCHAR(100))
- MarkusWinand 8y agoThanks for pointing out! The syntax used by SQL Server doesn't follow the standard. Or, in other words, the standard syntax gives an error in SQL server. However, I'll note that there is an alternative syntax in future versions of these slides. Thanks again.