Êý¾Ý¿â±í±¸·ÝÒÔ¼°»¹Ô­µÄ²Ù×÷

±¸·ÝÊý¾Ý±íÒÔ¼°»Ö¸´Êý¾Ý¿â±íµÄ¼òµ¥²Ù×÷

±¸·ÝÊý¾Ý¿âÖеÄÔ­±í，ÀýÈç：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