记录下复制T3常用PZ操作

凌酱

已于 2024-02-19 15:45:27 修改

阅读量392

点赞数 9

文章标签：数据库 sql

于 2024-01-12 15:32:12 首次发布

本文链接：https://blog.csdn.net/ivasox/article/details/135553805

版权

本文详细描述了如何在SQL中使用IDENTITY_INSERT开关对GL_bfreq表进行批量插入和删除操作，包括设置和关闭IDENTITY_INSERT模式，以及执行相应的数据迁移命令。

摘要由CSDN通过智能技术生成

SET IDENTITY_INSERT [TABLE_NAME] ON;
INSERT INTO [GL_bfreq] ([i_id], [c_id], [inid],........, [IsYx]) SELECT [i_id], [c_id], [inid], ......, [IsYx] FROM [UFDATA_999_2023].[dbo].[GL_bfreq]
SET IDENTITY_INSERT [TABLE_NAME] OFF;

SELECT * FROM GL_bfreq

DELETE FROM GL_bfreq

SET IDENTITY_INSERT GL_bfreq ON;
INSERT INTO [GL_bfreq] ([i_id], [c_id], [inid], [csign], [ctext], [idoc], [cdigest], [ccode], [md], [mc], [csettle], [cdept_id], [cperson_id], [ccus_id], [csup_id], [citem_id], [citem_class], [md_f], [mc_f], [nfrat], [nd_s], [nc_s], [cexch_name], [cn_id], [cname], [ccodecontrol], [ccode_equal], [dt_date], [cf_name], [IsYx]) SELECT [i_id], [c_id], [inid], [csign], [ctext], [idoc], [cdigest], [ccode], [md], [mc], [csettle], [cdept_id], [cperson_id], [ccus_id], [csup_id], [citem_id], [citem_class], [md_f], [mc_f], [nfrat], [nd_s], [nc_s], [cexch_name], [cn_id], [cname], [ccodecontrol], [ccode_equal], [dt_date], [cf_name], [IsYx] FROM [UFDATA_999_2023].[dbo].[GL_bfreq]
SET IDENTITY_INSERT GL_bfreq OFF;