sql server 查询数据拼装成update语句

最新推荐文章于 2022-11-02 14:08:10 发布

走错路的程序员

最新推荐文章于 2022-11-02 14:08:10 发布

阅读量505

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/phker/article/details/107712049

版权

数据库专栏收录该内容

5 篇文章 0 订阅

订阅专栏

sql server 查询数据成update语句

select top 100 
mkbarcode,
'update  report set reportpath='''+reportpath
+''' where barcode='''+barcode 
+''' and testaimscode='''+ testaimscode
+''' and InspectionCode=''' + InspectionCode
+''' and PatientName='''+PatientName
+''' and sourcekey='''+  CONVERT(VARCHAR(100), sourcekey COLLATE Chinese_PRC_CI_AS)
+''' and sourcetype='''+ CONVERT(VARCHAR(100), sourcetype ) +'''' 
from w_report 
where pdfreportpath like '%userupload%'
 and  reporttime > '2020-07-20'