备份数据表以及恢复数据库表的简单操作
备份数据库中的原表,例如:INITIAL_TABLE
备份表的表名: BAK_TABLE
备份:
create table BAK_TABLE
as
select * from INITIAL_TABLE
go
恢复:
delete from INITIAL_TABLE
go
insert into INITIAL_TABLE
select * from BAK_TABLE
go
create table BAK_TABLE
as
select * from INITIAL_TABLE
go
delete from INITIAL_TABLE
go
insert into INITIAL_TABLE
select * from BAK_TABLE
go