🚀 go-pugleaf

Q������Ҫ��һ����ϯ��ѯ��ad hoc query���д�һ��Զ�̵�OLEDB���Դ��ʹ��������
�루BULK LOAD���ķ�ʽ����ݵ��뵽SQL Server���ڣ�

A��
�����ʹ��Transact-SQL�е�OPENROWSET��������ȡ���κ�֧��ע��OLEDB���ṩ����
registered OLD DB provider�������Դ��ȡ��ݣ�����Զ��SQL Serverʵ���Microso
ft Access�������ʹ��OPENROWSET����һ��SQL Serverʵ���ȡ��ݣ���ô��ʵ�����
������Ϊ���?ϯ�ֲ�ʽ��ѯ��

Ҫ��ʵ������Ϊ֧�ּ�ϯ��ѯ����Ҫʹ��sp_configureϵͳ�洢����������������ã�

EXEC sp_configure 'show advanced options', 1; 
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE;
GO

һ�����Ѿ�������Զ��SQL Serverʵ�������ʹ��OPENROWSET��������ѯ��ʵ���
����Ӧ�ñ�����SELECT����FROM�﷨�С����µ��﷨��ʾ�˸ú���Ļ�Ԫ�أ�

OPENROWSET('provider', 'connection string', target)

�÷���˵�������ʹ��OPENROWSET������в�ѯ��

SELECT Employees.*
FROM OPENROWSET(
'SQLNCLI',
'Server=SqlSrv1;Trusted_Connection=yes',
'SELECT EmployeeID, FirstName, LastName, JobTitle
FROM AdventureWorks.HumanResources.vEmployee
ORDER BY LastName, FirstName'
) AS Employees

��֮ǰ���ᵽ�ģ�����Դ�SQL Server��������Դ��ȡ��ݡ����磬���µ�SELECT��
���ѯ��Microsoft Access��ݿ��е�Employees�?

SELECT Employees.*
FROM OPENROWSET(
'Microsoft.Jet.OLEDB.4.0',
'C:\Data\Employees.mdb';'admin';' ',
'SELECT EmployeeID, FirstName, LastName, JobTitle
FROM Employees
ORDER BY LastName, FirstName'
) AS Employees

��������������һ��OPENROWSET�����������Ҫ����--�������루Bulk Load����Ϊ��˵
���乤��ԭ�?��ʹ�������µĴ����������ͽ�Employees�?��Adventureworks��ݿ�
��

USE AdventureWorks
GO
UPDATE Employees 
SET ResumeFile = (
SELECT *
FROM OPENROWSET(BULK 'C:\Data\Employee1.docx', SINGLE_BLOB) 
AS ResumeContent)
WHERE EmployeeID = 1

���ڸú���ĸ�����飬��ο�SQL Server��������"OPENROWSET (Transact-SQL)"��
�塣

--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.31]