1.共四点
image.png
8793b16909ff4474ba74f5c70b27ef3f.png
6b7f605ef1e642b396fb1fde3883db4b.png
image.png
image.png
f583210a0fe94b5e94d05f202afd4b4c.png
将库中存在的表T_YWGY_DZJZ_JZ的一些数据插入到库中不存在的表JZ_DATA中
- 创建造数据的 JZ的临时表
SELECT newid() C_BH_new, C_BH, C_BH_AJ, N_AJLB, DT_GEN_TIME, C_MC, N_Flag, C_PdfFile, C_PdfFile_ZJ, C_FilePath, C_FilePath_ZJ, N_FCYS, N_ZJFYSY, N_FJFYSY, N_PDFDX, C_ZJFP_LJ, C_FJFP_LJ, N_FYID, C_YWBS, N_STATE, D_BUILD_TIME, C_YWLX, C_XTBS, N_YJCS, N_SFBQY
INTO JZ_DATA
FROM dbo.T_YWGY_DZJZ_JZ
将库中存在的表JZ_DATA反插回库中存在的表T_YWGY_DZJZ_JZ中
insert INTO T_YWGY_DZJZ_JZ
SELECT C_BH, C_BH_AJ, N_AJLB, DT_GEN_TIME, C_MC, N_Flag, C_PdfFile, C_PdfFile_ZJ, C_FilePath, C_FilePath_ZJ, N_FCYS, N_ZJFYSY, N_FJFYSY, N_PDFDX, C_ZJFP_LJ, C_FJFP_LJ, N_FYID, C_YWBS, N_STATE, D_BUILD_TIME, C_YWLX, C_XTBS, N_YJCS, N_SFBQY
FROM dbo.JZ_DATA
go
