title: Insert text into TEXT column from a file
body: <p>What is the easiest way - preferably just using SQL Server Management Studio - to insert text into a <code>Text</code> type column (<code>text, ntext, varchar(max), nvarchar(max)</code>) from a file.</p>
  
  <p>Say a have a table</p>
  
  <pre><code>textFileContent(id, textData)
  </code></pre>
  
  <p>and want to do </p>
  
  <pre><code>insert into textFileContent(textData)
  values([data read from a file, complete file content])
  </code></pre>
  
  <p>Also, is it possible to do update in a similar manner? E.g.</p>
  
  <pre><code>update textFileContent
  set textData = [data read from a file,  complete file content]
  where id = 1
  </code></pre>