title: SQL Server nested quotes - how to?
body: <p>I've been looking for this for the past hour, but could not find any indication of this being possible. </p>
  
  <p>In Oracle there is the ability to do nested quotes in the form of: <br></p>
  
  <pre><code>Set @variable = q'[ *big sql block here* ]'
  </code></pre>
  
  <p>With this you didn't have to worry about escaping each string and row in a dynamic/static query or such.</p>
  
  <p>But with SQL Server, i've searched and the only option available seems to be the double quotation/apostrophe. </p>
  
  <p>Any ideas?</p>
  
  <p>Appreciate it and apologize if this was asked before - but using my search parameters i could not find anything on this (maybe i'm just not using the correct jargon). </p>