根据已知查询插入到某表的sql写法_查询表填入表格中sql 前端怎么写-优快云博客

本文详细介绍了一种针对CRM系统中客户数据的批量更新方法，通过使用SQL语句结合序列生成器，实现了对特定部门ID的数据进行高效更新，同时展示了如何在更新过程中保持数据的一致性和准确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

INSERT INTO BO_CRM_CLIENT_SERDPT
(ID,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH)
SELECT BO_CRM_CLIENT_SERDPT_SEQ.NEXTVAL,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
(SELECT DEPARTMENTNAME FROM ORGDEPARTMENT WHERE ID = BMID) BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM (SELECT ORGNO,
BINDID,
SYSDATE CREATEDATE,
'admin' CREATEUSER,
SYSDATE UPDATEDATE,
'admin' UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
(CASE BMID
WHEN CAST('7880' AS NVARCHAR2(100)) THEN
CAST('51876' AS NVARCHAR2(100))
WHEN CAST('7882' AS NVARCHAR2(100)) THEN
CAST('51889' AS NVARCHAR2(100))
WHEN CAST('7879' AS NVARCHAR2(100)) THEN
CAST('51893' AS NVARCHAR2(100))
WHEN CAST('7881' AS NVARCHAR2(100)) THEN
CAST('51903' AS NVARCHAR2(100))
WHEN CAST('45807' AS NVARCHAR2(100)) THEN
CAST('51907' AS NVARCHAR2(100))
WHEN CAST('32809' AS NVARCHAR2(100)) THEN
CAST('51937' AS NVARCHAR2(100))
WHEN CAST('46837' AS NVARCHAR2(100)) THEN
CAST('51942' AS NVARCHAR2(100))
WHEN CAST('45790' AS NVARCHAR2(100)) THEN
CAST('51950' AS NVARCHAR2(100))
WHEN CAST('45762' AS NVARCHAR2(100)) THEN
CAST('51963' AS NVARCHAR2(100))
WHEN CAST('45764' AS NVARCHAR2(100)) THEN
CAST('51970' AS NVARCHAR2(100))
WHEN CAST('45760' AS NVARCHAR2(100)) THEN
CAST('51979' AS NVARCHAR2(100))
WHEN CAST('45768' AS NVARCHAR2(100)) THEN
CAST('51995' AS NVARCHAR2(100))
WHEN CAST('45784' AS NVARCHAR2(100)) THEN
CAST('52002' AS NVARCHAR2(100))
WHEN CAST('45786' AS NVARCHAR2(100)) THEN
CAST('52014' AS NVARCHAR2(100))
WHEN CAST('45782' AS NVARCHAR2(100)) THEN
CAST('52022' AS NVARCHAR2(100))
WHEN CAST('7896' AS NVARCHAR2(100)) THEN
CAST('52004' AS NVARCHAR2(100))
WHEN CAST('7895' AS NVARCHAR2(100)) THEN
CAST('52016' AS NVARCHAR2(100))
WHEN CAST('45772' AS NVARCHAR2(100)) THEN
CAST('51904' AS NVARCHAR2(100))
WHEN CAST('45774' AS NVARCHAR2(100)) THEN
CAST('51911' AS NVARCHAR2(100))
WHEN CAST('45776' AS NVARCHAR2(100)) THEN
CAST('51917' AS NVARCHAR2(100))
WHEN CAST('45778' AS NVARCHAR2(100)) THEN
CAST('51921' AS NVARCHAR2(100))
WHEN CAST('45770' AS NVARCHAR2(100)) THEN
CAST('51931' AS NVARCHAR2(100))
WHEN CAST('45788' AS NVARCHAR2(100)) THEN
CAST('51936' AS NVARCHAR2(100))
WHEN CAST('7911' AS NVARCHAR2(100)) THEN
CAST('51877' AS NVARCHAR2(100))
WHEN CAST('32811' AS NVARCHAR2(100)) THEN
CAST('51879' AS NVARCHAR2(100))
WHEN CAST('32810' AS NVARCHAR2(100)) THEN
CAST('51880' AS NVARCHAR2(100))
WHEN CAST('45780' AS NVARCHAR2(100)) THEN
CAST('51882' AS NVARCHAR2(100))
WHEN CAST('46601' AS NVARCHAR2(100)) THEN
CAST('52032' AS NVARCHAR2(100))
END) BMID,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM BO_CRM_CLIENT_SERDPT
WHERE BMID IN (7880,
7882,
7879,
7881,
45807,
32809,
46837,
45790,
45762,
45764,
45760,
45768,
45784,
45786,
45782,
7896,
7895,
45772,
45774,
45776,
45778,
45770,
45788,
7911,
32811,
32810,
45780,
46601));