Como usar o OUTPUT para capturar ID novo e antigo?
Por exemplo, digamos que eu tenho,
create table product
(
ID INT IDENTITY(1,1) NOT NULL,
Name VARCHAR(10)
)
insert into product(Name) values('a')
insert into product(Name) values('b')
insert into product(Name) values('c')
insert into product(Name) values('d')
insert into product(Name) values('e')
create table #tempproduct
(
ID INT IDENTITY(1,1) NOT NULL,
Name VARCHAR(10)
)
declare @OutputAttributesValues table
(
[NewID] INT,
[OldID] INT
)
insert into #tempproduct(Name)
OUTPUT INSERTED.[ID],[ID] INTO @OutputAttributesValues
select [Name] FROM product
Veja Preciso obter o ID antigo e novo da saída. Mas este sql me dando erro "Invalid column name 'ID'."http://sqlfiddle.com/#!3/a27b2/1