开发者

Equivalent of SET IDENTITY_INSERT OFF in Access

As the title suggests, is ther开发者_JAVA技巧e any way of turning off an autonumber field in Access to allow me to insert a row with an id of my choosing, such as you would do with SET IDENTITY_INSERT OFF in SQL Server?


You can insert an ID with SQL.

INSERT INTO Table1 (ID) Values (-10)


The autonumber property sets a field's default value as the autonumber seed value. If the autonumber field is also the primary key (or has a separate unique constraint), you can't re-use any of the stored values. However, you can explicitly insert any long integer value which doesn't conflict with the existing stored values. And without a unique constraint on the autonumber field you can insert the same value repeatedly.

You may not really even need the equivalent of SET IDENTITY_INSERT OFF

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜