title: How do I upload a file to a varbinary(max) column in SQL Server 2008, using TSQL?
body: <p>This must be possible because I believe I've done it before. Here's my query:</p>
  
  <pre><code>insert into exampleFiles Values(NEWID(), cast('c:\filename.zip' as varbinary(max))
  </code></pre>
  
  <p>Obviously that just inserts the text in between the quotes and not the file from that location.  There must be a simple tsql bit of language that I'm forgetting. Thanks</p>