SqlServer的批量upsert
从临时表复制
MERGE INTO (SELECT id,name,url from newweb) AS table
USING (SELECT ? sd id,? as name,? as url) AS data
ON table.id = data.id
WHEN MATCHED THEN
UPDATE SET table.name = data.name,table.url=...
原创
2019-01-14 09:26:59 ·
884 阅读 ·
1 评论