Hey guys,
Main Directory
sub directory 1
Files(Images, Excel, Word, Text, PDF)
sub directory 2
Files(Images, Excel, Word, Text, PDF)
sub directory 2
Files(Images, Excel, Word, Text, PDF)
sub directory 2
Files(Images, Excel, Word, Text, PDF)
Here, I want to store each Files in each sub directory into SQL Server Management Studio.
Can anyone tell me how to do it.
Thanks.
What I have tried:
USE DB
GO
CREATE TABLE Test1(
Name nvarchar(255) NOT Null,
Type nvarchar(255) Null,
BinaryData varbinary(Max) Null,
Primary Key(Name)
) ON [PRIMARY]
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO
Insert Test1([Name],[Type],[BinaryData])
Select 'detail1.pdf','PDF file', BulkColumn from Openrowset( Bulk
'C:\Database\detail1.pdf', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'detail2.pdf','PDF file', BulkColumn from Openrowset( Bulk
'C:\Database\detail2.pdf', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'detail1.pdf','PDF file', BulkColumn from Openrowset( Bulk
'C:\Database\detail3.pdf', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'detail1.pdf','PDF file', BulkColumn from Openrowset( Bulk
'C:\Database\detail4.pdf', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'image1.png','imagefile', BulkColumn from Openrowset( Bulk
'C:\Database\image1.png', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'image2.png','imagefile', BulkColumn from Openrowset( Bulk
'C:\Database\image2.png', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'doc1.doc','Docfile', BulkColumn from Openrowset( Bulk
'C:\Database\doc1.doc', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'doc2.doc','Docfile', BulkColumn from Openrowset( Bulk
'C:\Database\doc2.doc', Single_Blob) as DATA
Insert Test1([Name],[Type],[BinaryData])
Select 'contain.txt','TextFile', BulkColumn from Openrowset( Bulk
'C:\Database\contain.txt', Single_Blob) as DATA