在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屋!
查看全文