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
Newer Post
Older Post
Home