December 15, 2009

Converting Binary Data to TEXT or DOC Files

Question:
We stored 26000 resumes as binary data in SQL database 2005.
Is there any process to export binary data to Text or Doc files ? any help is appreciated.
Thanks !

Ans:

sys.fn_sqlvarbasetostr THIS IS A SQL SERVER BUILT IN FUNTION
USE LIKE THIS


select sys.fn_sqlvarbasetostr(column_name) AS TEXT_VALUE from table