SET IDENTITY_INSERT [表名] ON //开放自增字段INSERT INTO [目标表名]([字段]) select [字段] from [表名]SET IDENTITY_INSERT [表名] off //恢复锁定自增字段
这篇文档对您是否有帮助?