Extracting out Blob

Posted on 2011-04-19
Last Modified: 2012-06-22
Hi, experts -
I have a few word documents stored in blob columns (sql 2005); how can I extract them out and save them back into file system as .doc files, thanks.
Question by:ivan_belal
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    That question is actually about file stream, but the same technique can be used for blobs.

    Author Comment

    I needed in t-sql way if possible.
    LVL 22

    Accepted Solution

    BCP seems to do the trick. See for example:
    Or Google on:
    tsql blob save bcp
    for more information and hints.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>I needed in t-sql way if possible. <<
    If all you can use is T-SQL than you will have to resort to using OPENROWSET()

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now