Saturday, 19 July 2014

SQL Insert duplicate data in to same table

SQL Insert duplicate data in to same table
SQL Select and Insert statement

Insert into <MyTable> Select * from <MyTable>
Or
Insert into <MyTable> Select ID,Name from <MyTable>