T-SQL insert with output expression

0 votes

1 answer

424 views

                              insert Table1
    OUTPUT inserted.ID, s.[Id] 
    INTO @Inserted
    select 
    s.[Field1],
    s.[Field2],
    from 
    @TableVariable s

why is s.[Id]  marked by red line ? Is it non-correct syntax to save value in @Inserted table variable ?
                        

Asked by Vladyslav Furdak (241 rep)

Jun 7, 2016, 03:35 PM
Last activity: Jun 7, 2016, 04:35 PM

T-SQL insert with output expression

Related Questions