sqlserver 获取更新后的数据 

UPDATE crawler_property_copy1 
SET remark = '无' OUTPUT DELETED.id AS [Before],
Inserted.id AS [After] 
WHERE
	remark IS NULL

在这里插入图片描述

posted @ 2019-05-15 16:13  qwer78  阅读(89)  评论(0)    收藏  举报