Aquí nuestro código de ejemplo:  DECLARE @tabla TABLE (ticketId int, code varchar(10)); INSERT INTO TicketBack(ticketId, matchDay, code, creditID) output inserted.ticketId, inserted.code into @tabla SELECT ticketId, MatchDay, code, creditID FROM dbo.Tickets WHERE ticketid > 100 select * from @tabla