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