把一個(gè)庫里的表+數(shù)據(jù)放到另一個(gè)庫中
USE [A]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MyTable]') AND type in (N'U'))
DROP TABLE [dbo].[
MyTable]
USE [B]
select * into A.dbo.MyTable from MyTable
如果A庫中有表MyTable，則刪除，然后把B庫中的MyTalbe復(fù)制到A庫中