Copy BLOB to BLOB using TSQL

5 pts.
Tags:
BLOB
BLOB TSQL
SQL Server 2008
SQL Server 2008 R2
Is there a way I can copy a BLOB from one column to another using TSQL ?

Software/Hardware used:
SQL 2008 R2
ASKED: November 18, 2010  1:37 AM
UPDATED: November 19, 2010  8:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You could use an UPDATE statement (almost) as you would with other type of columns, but this could not be recommended depending on the amount of data being moved.

—————

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    Did U mean copy a SQL Binary Large Object (BLOB) from one database to another....
    26,090 pointsBadges:
    report
  • Kccrosser
    The question isn't very clear. If you just want to copy a blob item from one RECORD to another, you can do that with a simple update statement, e.g.: update DestinationTable set DestinationBLOBColumn = (select SourceBLOBColumn from SourceTable where sourcecondition = xxx) where destinationcondition = xxx If you need to do this with more than one record, then I would recommend using a cursor and committing each record as you go, to avoid creating huge rollback segments.
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following