This is a follow up post of http://visakhm.blogspot.com/2011/08/multiple-table-insertion-using-single.html In the above post I’ve illustrated how Composable DML feature can be applied for simultaneous insert to parent child tables. I was trying to use this feature in a similar scenario when…
Multiple table insertion using single statement is this possible?
This was one of question asked in a interview. The obvious answer would be no without using a view until SQL 2008. But in SQL 2008 this is possible without the use of view by means of a newly introduced…