I am fairly new to T-SQL and have a challenging task.
I need to extract some records off a sql table, and one of the fields is a BLOB. The table holds all attachments for a main table. I need to be able to read the blob field as we are losing this particular sql server.
Just extracting the raw data takes an eternity, without converting the Blob to a readable text field.
Any pointers at this stage would be greatly appreciated