SQLServer批量更新

两种写法,暂未知道区别

1.

UPDATE a
SET a.resblockid = (
SELECT b.resblockId
FROM yyy.dbo.yyy b
WHERE a.unitId = b.id
)
FROM xxx.dbo.xxx a;

2.

UPDATE a
SET a.brokerId = b.brokerId,
a.brokerAssignedBy = b.brokerAssignedBy,
a.brokerAssignedTime = b.brokerAssignedTime
FROM
xxx.dbo.xxx a ,yyy.dbo.yyy b
WHERE
a.unitId = b.unitId;

上一篇:android sdk manager 代理设置(送给牛逼的)


下一篇:JAVA HTTP请求 常用的代理设置