<div>
Please Can u explain me detaily.<br />
<br />
For example I want to store the image data from db to on file name like C:\fetched.doc.<br />
<br />
Thanks for your quick reply.
</div>


<div>
Are you looking to do this purely in SQL server, or do you have a client application that will do the actual work of writing the text files? Writing binary data to files using TSQL will be messy at best.
</div>


<div>
Yes. I am looking it in purely in SQL server. 
</div>


<div>
<div class="content wysiwyg-content">
Hi friends,<br />
<br />
<br />
I want to retrieve the image data type data like .doc,.jpg,.pdf files from SQL Sever through TSQL. <br />
<br />
Thanks and regards
</div>
</div>


Hi friends,


I want to retrieve the image data type data like .doc,.jpg,.pdf files from SQL Sever through TSQL. 

Thanks and regards

Please Can u explain me detaily.

For example I want to store the image data from db to on file name like C:\fetched.doc.

Thanks for your quick reply.

Are you looking to do this purely in SQL server, or do you have a client application that will do the actual work of writing the text files? Writing binary data to files using TSQL will be messy at best.

Yes. I am looking it in purely in SQL server. 

How to fetch image data (doc,jpg,pdf) from sqlserver2005 to file using TSQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.