概述:
比如现有数据表StudentInfo,现要把这个表备份.
实现:
SQL Server做法如下:
比如现有数据表StudentInfo,现要把这个表备份.
实现:
SQL Server做法如下:
select *
into StudentInfoBackup
from StudentInfo
Oracle做法如下:into StudentInfoBackup
from StudentInfo
create table studentinfobackup
as
select * from studentinfo
as
select * from studentinfo