连接(join)
Terry Purcell 谈外连接(第一部分)
把Access数据(.mdb)导入到SQLServer2005数据库表中
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
insert into dbo.Topic select * from opendatasource('Microsoft.Jet.OLEDB.4.0','Data Source="c:/Topic.mdb";User ID=Admin;Password=')... Topic