SQL Server Bulk Import catalog file _mssql

OpenRowset usage can refer to the MSDN
Http://technet.microsoft.com/zh-cn/library/ms190312.aspx
If there are many files, it is recommended to use the program to pour

Copy Code code as follows:

if (object_id (' T_bulkresult ') is not null)
drop table T_bulkresult
CREATE TABLE T_bulkresult (name varchar (1000), data image)
Go
DECLARE @d varchar (1000)
Set @d = ' c:\test\ '
CREATE TABLE #tb (FName varchar (1000), d int, F int)
INSERT INTO #tb exec xp_dirtree @d, 1, 1
Delete from #tb where F <> 1
DECLARE @ SQL nvarchar (max)
SELECT @ sql = ISNULL (@ SQL, ') + ' insert into T_bulkresult select ' ' +@d + fname + ' ", * FROM OPENROWSET (BULK N '" ' +@ D + fName + ' ", Single_blob) b
'
From #tb A
EXEC sp_executesql @ sql
drop table #tb
SELECT * FROM T_bulkresult