SQL表复制与备份复原

--如果目的表已经存在:insert into DATAHR.DBO.GBITEMselect * from DEMO.DBO.GBITEM--如果目的表不存在:select * into DATAHR.DBO.GBITEMfrom DEMO.DBO.GBITEM--跨库导入select * into [zk_news].[dbo].[News1] from [zk_media].[dbo].[News]--备份数据库OFSysBACKUP DATABASE OFSys to disk = 'e:/OFSys'还原restore database test from disk = 'c:\test'

?