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
No comments:
Post a Comment