Skip to content
Advertisement

EF Core Insert operation – how does the SQL command work?

How does the following SQL command works?

(It was generated by EF Core and it inserts some OrderLine entities).

Edit:
I understand the declaring of the TABLE type variable and have basic idea of MERGE operation. But having a hard time understanding how and when actually data gets inserted in the OrderLine table.

Advertisement

Answer

how and when actually data gets inserted in the OrderLine table.

The operative bit is ON 1=0

Which means rows are never matched, and so every row goes to

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement