文本吗?select * from opendatasource('MICROSOFT.JET.OLEDB.4.0','Text;HDR=Yes;DATABASE=d:\')...[2#txt]
IF OBJECT_ID ('file_table', 'U') IS NOT NULL DROP TABLE file_table; GO CREATE TABLE file_table(FileName nvarchar(60), FileType nvarchar(60), Document image)INSERT INTO file_table(FileName, FileType, Document) SELECT 'jpgfile.jpg' AS 文件名, '.jpg' AS 文件类型, * FROM OPENROWSET(BULK 'C:\jpgfile.jpg', SINGLE_BLOB) AS DOCUMENTSELECT * FROM file_table
IF OBJECT_ID ('file_table', 'U') IS NOT NULL DROP TABLE file_table; GO CREATE TABLE file_table(FileName nvarchar(60), FileType nvarchar(60), Document image)INSERT INTO file_table(FileName, FileType, Document) SELECT 'rarfile.rar' AS 文件名, '.rar' AS 文件类型, * FROM OPENROWSET(BULK 'C:\rarfile.rar', SINGLE_BLOB) AS DOCUMENTSELECT * FROM file_table
from opendatasource('MICROSOFT.JET.OLEDB.4.0','Text;HDR=Yes;DATABASE=d:\')...[2#txt]
DROP TABLE file_table;
GO
CREATE TABLE file_table(FileName nvarchar(60), FileType nvarchar(60), Document image)INSERT INTO file_table(FileName, FileType, Document)
SELECT 'jpgfile.jpg' AS 文件名, '.jpg' AS 文件类型, *
FROM OPENROWSET(BULK 'C:\jpgfile.jpg', SINGLE_BLOB) AS DOCUMENTSELECT * FROM file_table
DROP TABLE file_table;
GO
CREATE TABLE file_table(FileName nvarchar(60), FileType nvarchar(60), Document image)INSERT INTO file_table(FileName, FileType, Document)
SELECT 'rarfile.rar' AS 文件名, '.rar' AS 文件类型, *
FROM OPENROWSET(BULK 'C:\rarfile.rar', SINGLE_BLOB) AS DOCUMENTSELECT * FROM file_table