SQL Server自己増分列の次のIdを取得

937 ワード

IDENT_CURRENT('TableName')         ,IDENT_INCR('TableName')         ,             
SELECT IDENT_CURRENT('TableName') + IDENT_INCR('TableName');
    :https://social.microsoft.com/Forums/zh-CN/07c3a188-5ae1-4623-ba14-0ae2148f5be0/sql-server-id?forum=sqlserverzhchs
MSDN Reference :https://msdn.microsoft.com/en-us/library/ff848728.aspx

転載先:https://www.cnblogs.com/makesense/p/5646747.html