Home Forums SQL Server 2012 SQL Server 2012 - T-SQL update output into RE: update output into
T.Ashish
SSCarpal Tunnel
Points: 4248
More actions
May 24, 2013 at 5:26 am
#1618189
Use OUTPUT INSERTED.a into @foo2 If you want to get the inserted value.
Use OUTPUT DELETED.a into @foo2 If you want to get the value replaced by update statement.