“SET IDENTITY OFF”的类似语法在Ms Access中 [英] Similar syntax of "SET IDENTITY OFF" in Ms Access

问题描述

你好，



我想将记录从一个数据库复制到MS-Access数据库中的其他数据库。



我有一些表，其ID作为外键存储在其他表中。



现在我想要一些与sql的SET IDENTITY OFF类似的语法女士访问



任何人都可以帮助我。

hello,

I want to copy records from one database to other database in MS-Access database.

I have some table whose ID is stored as foreign key in other table.

Now i want something Similar syntax to "SET IDENTITY OFF" of sql in Ms Access

can any body help me.

推荐答案

Access中没有等效的。但是，您可以在INSERT语句中为ID列指定所需的值，只要它与现有记录不冲突。

There is no equivilent in Access. You can, however, just specifiy the value you want for the ID column in the INSERT statement, so long as it doesn''t conflict with an existing record.

这篇关于“SET IDENTITY OFF”的类似语法在Ms Access中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！