Home Forums SQL Server 2012 SQL Server 2012 - T-SQL update output into RE: update output into
Bhaskar.Shetty
Hall of Fame
Points: 3054
More actions
May 24, 2013 at 5:15 am
#1618182
Try this...
update foo
set b = 'this is'
OUTPUT DELETED.a INTO @foo2
from foo f
inner join bar b
on f.c = b.y
DELETED.a will update previous value and INSERTED.a will update the new value in @foo2 table.