title: How do I declare and assign a variable on a single line in SQL
body: <p>I want something like</p>
  
  <pre><code>DECLARE myVariable nvarchar[MAX] = "hello world".
  </code></pre>
  
  <p>Bonus points if you show me how to encode a quote in the string.</p>
  
  <p>E.g.:</p>
  
  <p>I want the string to read</p>
  
  <pre><code>John said to Emily "Hey there Emily"
  </code></pre>
  
  <p>my attempt would be</p>
  
  <pre><code>DECLARE myVariable nvarchar[MAX] = "John said to Emily \"Hey there Emily\""
  </code></pre>