流程组人员的快速复制

最新推荐文章于 2025-12-21 18:16:17 发布

原创最新推荐文章于 2025-12-21 18:16:17 发布 · 696 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#filter

金和C6 同时被 2 个专栏收录

44 篇文章

订阅专栏

SQL

34 篇文章

订阅专栏

--流程组人员的快速复制。
select * from filter where
moduleid ='flowgroup'
and
filtertitle like '%阀门采购%'

--阀门替换
update filter set filtercontent=(select filtercontent from filter where filterid='1006')
where filterid='1116'
--重工替换
update filter set filtercontent=(select filtercontent from filter where filterid='1001')
where filterid='1114'
--气瓶替换
update filter set filtercontent=(select filtercontent from filter where filterid='1005')
where filterid='1115'
--撬装替换
update filter set filtercontent=(select filtercontent from filter where filterid='1022')
where filterid='1117'
--工程事业部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1065')
where filterid='1118'
--总部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1021')
where filterid='1120'

－－－－－－－－－－销售－－－－－－－－－－－－－

--阀门替换
update filter set filtercontent=(select filtercontent from filter where filterid='1004')
where filterid='1122'
--重工替换
update filter set filtercontent=(select filtercontent from filter where filterid='1002')
where filterid='1125'
--气瓶替换
update filter set filtercontent=(select filtercontent from filter where filterid='1003')
where filterid='1121'
--撬装替换
update filter set filtercontent=(select filtercontent from filter where filterid='1023')
where filterid='1124'
--工程事业部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1076')
where filterid='1118'
--总部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1101')
where filterid='1126'