title: SQL Server 2008 R2: Best way to export BLOB and other column data out to the file system
body: <p>I have read some arts about BCP or CLR code that will export BLOBs to individual files on the hard drive, but I need to BCP or CLR out the entire table data together (meaning the other columns which are character or integer or datetime data need to come out as a whole) I need to make sure I can BCP/CLR the data back into the table and have the same linking between BLOBs and other column data.</p>
  
  <p>Any ideas? </p>