<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

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.