title: Copying a large field (varbinary(max)) to file / clipboard
body: <p>I have a VARBINARY(MAX) field in a database table which contains ~35k characters. This field is a converted word document which unfortunately no longer have access to.</p>
  
  <p>This field is present in my dev database and I'm looking to port this value to a live database. However, if I purely select the contents out of the grid results in SQL I seem only to get ~28k of the available characters. </p>
  
  <p>So my question is this, what's the best way to migrate a field which has contents too large to simple copy and paste into and insert script? </p>
  
  <p>Any thoughts greatly appreciated.</p>
  
  <p>EDIT: </p>
  
  <p>As additional info, outputting the results to file (albeit to .txt) seem to give me less chars than via grid. If I export the query results to file post running the query to grid I seem to get a literal representation of what's in the query window at the time (so if I stretch the window I get more characters than if I compress the column width)</p>