表的导入，导出

  if  exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LibraryCheck]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop Table LibraryCheck;

 SELECT  * INTO LibraryCheck
    FROM  OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=.;User ID=sa;Password=sa'
         ).library.dbo.LibraryCheck

 

 

如果要导出到文本，就应用 bulk insert 与 bcp等方法