asked on
Iterate through a collection of files in T-SQL
I want to iterate through all the jpeg files in a folder, inserting them into a filestream column in SQL Server. I have a stored procedure to insert the files, but I don't know how to read through a series of folders and files using T-SQL.
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
Habib Pourfard
you can achive this by using xp_cmdshell commands and bulk copy.
ASKER
Can you give me an example?
here are some examples and explanations about the usage of xp_cmdshell and bcp
http://technet.microsoft.com/en-us/library/ms175046.aspx
http://sqlwithmanoj.wordpress.com/2011/09/09/bcp-in-out-queryout-the-bcp-util/
http://technet.microsoft.com/en-us/library/ms175046.aspx
http://sqlwithmanoj.wordpress.com/2011/09/09/bcp-in-out-queryout-the-bcp-util/
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.