Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Update binary column in a table

Author  Topic 

reddy_vam
Starting Member

43 Posts

Posted - 2010-03-03 : 13:34:38
Hi

Is anyone has anyidea how to export a table that is having binary column

I tried with export wizard but its not working
basically i want to update binary column values in other table.

Thanks,
Reddy

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-03-03 : 13:55:23
you can use bcp with the -n option to get the binary data.
example:
bcp databaseName..TableName out fielname.txt -n -SServerName -U userid -Ppassword

Go to Top of Page
   

- Advertisement -