Saturday, 19 July 2014

How to Create Backup table in SQL


Select * into <MyTableBackup> from <MyTable>
What it will do?
It will create new Table with name MyTableBackup same as MyTable structure
It will select data from MyTable  and insert in to MyTableBackup