Microsoft Techies
Microsoft information center.
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
‹
›
Home
View web version