Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Extracting Images and documents from table

Author  Topic 

pvccaz
Yak Posting Veteran

87 Posts

Posted - 2009-09-22 : 02:00:53
Hi,

There is a table in SQL server 2005 that has documents and images stored as binary data in a column. The data type of the column is varbinary(max). The images and documents were stored through in the table via a front end application.

Is there a way that i can extract the images and documents from this column using T-SQL and write it to a disk file.

Thanks,

pvccaz
Yak Posting Veteran

87 Posts

Posted - 2009-09-22 : 12:53:43
Is there any bcp command that can do this.?
Go to Top of Page
   

- Advertisement -