title: SQL INSERT, Force Truncate Field
body: <p>I have input data containing some "rogue" fields that are longer than the corresponding database field. This causes my import script, which uses SQL INSERT statements to fall over with a warning:</p>
  
  <pre><code>Msg 8152, Level 16, State 13, Line 2
  String or binary data would be truncated.
  </code></pre>
  
  <p>How can I force truncation of these fields and enable my script to complete?</p>