更新表中所有符合条件的数据--使用…

最新推荐文章于 2024-03-24 10:04:58 发布

lovejesuslove

最新推荐文章于 2024-03-24 10:04:58 发布

阅读量416

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/lovejesuslove/article/details/50943808

版权

SQL 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

--------------补全数据-------------------
update b set b.客户报告编号=a.客户报告编号 from FirstTable a inner join FinalTable b
on b.CrediteyesNO=a.CrediteyesNO where a.客户报告编号 is not null and b.客户报告编号 is null

update b set b.运营地址=a.运营地址 from FirstTable a inner join FinalTable b
on b.CrediteyesNO=a.CrediteyesNO where a.运营地址 is not null and b.运营地址 is null

update b set b.主营业务=a.主营业务 from FirstTable a inner join FinalTable b
on b.CrediteyesNO=a.CrediteyesNO where a.主营业务 is not null and b.主营业务 is null

update b set b.建筑面积=a.建筑面积 from FirstTable a inner join FinalTable b
on b.CrediteyesNO=a.CrediteyesNO where a.建筑面积 is not null and b.建筑面积 is null

--------------显示数据条数>>>>>>>>>>>>>>>>>>>>>
select distinct CrediteyesNO into #No from 国内订单表 where 委托时间 ='2011-09-15 15:30:00.000'and 委托公司名称 = '上海阿斯利康' and 完成情况='已完成'
select CrediteyesNO into OtherNO from #No where #No.CrediteyesNO not in (Select CrediteyesNO from #temp1)