这里只列出来操作sql server 数据库的方法 ,这在导库的时候很有用
go
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=192.168.24.252;UID=sa;PWD=jh0101',
c6_aoruijing.dbo.users) AS a