update T_Test set Province = '湖南', City = '郴州'output'(更新前)' + deleted.Province + deleted.City as [更新前], '(更新后)' + inserted.Province + inserted.City as [更新后] where id = 2
还可以将返回的结果保存在表变量中,这在删除数据,并把删除的数据插入到历史表时很实用
DECLARE @tempTable TABLE(
id int,
Province varchar(50),
City varchar(50)
)
DELETEFROM TestTB OUTPUT deleted.* INTO @tempTable WHERE id > 4SELECT * FROM @tempTable