INSERT INTO multiple tables with a single SQL statement

INSERT INTO multiple tables with a single SQL statement

References

Reference NO 1

http://stackoverflow.com/questions/10471757/insert-rows-into-multiple-tables-in-a-single-query-selecting-from-an-involved-t

Reference NO 2

http://stackoverflow.com/questions/175066/sql-server-is-it-possible-to-insert-into-two-tables-at-the-same-time

Reference NO 3

http://hardforum.com/showthread.php?t=1223176

Reference NO 4

http://www.sqlservercentral.com/Forums/Topic1264035-392-1.aspx

Reference NO 5

http://probertson.com/articles/2009/11/30/multi-table-insert-one-statement-air-sqlite

Reference NO 6

http://forums.asp.net/t/prev/1315721

Reference NO 7

http://forums.devx.com/showthread.php?148804-SQL-Insert-data-in-Multiple-table-and-Update-at-same-time

Reference NO 8

http://www.techonthenet.com/sql/insert.php