Select data from table1 and copy it to table2

Select data from table1 and copy it to table2

References

Reference NO 1

http://stackoverflow.com/questions/12533953/copying-data-from-table1-to-table2-with-slightly-different-datatypes-names-and

Reference NO 2

http://stackoverflow.com/questions/12044996/trigger-to-copy-few-columns-from-table1-to-table2-automatically-when-new-data-is

Reference NO 3

http://forums.devshed.com/ms-sql-development-95/copy-data-from-table1-to-table2t-654482.html

Reference NO 4

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6dee8ffb-f529-4630-8cb5-8ac375b945ad/action?threadDisplayName=copy-all-the-data-from-table1-to-table2-with-table2-has-timestamp-column-extra

Reference NO 5

http://bytes.com/topic/sql-server/answers/693720-ms-sql-copy-new-modified-rows-table1-table2

Reference NO 6

https://forums.oracle.com/thread/2415807

Reference NO 7

http://www.bigresource.com/MS_SQL-MS-SQL-copy-new-and-modified-rows-from-TABLE1-to-TABLE2-hJ6c0Oyf.html

Reference NO 8

http://www.w3schools.com/sql/sql_insert_into_select.asp