34,590
社区成员
发帖
与我相关
我的任务
分享
-- 大概就是这样的语法
update A set A.col1= B.col1, A.col2 = B.col2 , .....
from mytable A , youtable B
where A.ID = B.ID and ........
update hdzx_question a set a.c_qusType=1
from [dbo].[BECBoardMessage] b
where a.c_deptId =b.c_deptId and b.Prop1='zx'
关联字段我自己帮你加的,对不对得看你真实业务UPDATE hdzx_question
SET c_qusType = 1
WHERE c_deptId = 52
AND EXISTS ( SELECT 1
FROM [dbo].[BECBoardMessage]
WHERE Prop1 = 'zx'
AND hdzx_question.id = BECBoardMessage.id ) --这个链接关系lz自己用相关字段连一下