在Access中等效于SET IDENTITY_INSERT OFF [英] Equivalent of SET IDENTITY_INSERT OFF in Access
本文介绍了在Access中等效于SET IDENTITY_INSERT OFF的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
正如标题所示，是否可以关闭Access中的自动编号字段以允许我插入具有自己选择的ID的行，例如您在SQL Server中对SET IDENTITY_INSERT OFF所做的操作?
As the title suggests, is there 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?
推荐答案
您可以使用SQL插入ID.
You can insert an ID with SQL.
INSERT INTO Table1 (ID) Values (-10)
这篇关于在Access中等效于SET IDENTITY_INSERT OFF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
