title: How to set multiple local variables in one line using T-SQL?
body: <pre><code>declare @inserted bit
  declare @removed bit
  </code></pre>
  
  <p>I know it's possible to set them like below:</p>
  
  <pre><code>SELECT @inserted = 0, @removed = 0
  </code></pre>
  
  <p>but would it be possible to make this even simpler and use something like:</p>
  
  <pre><code>SET @inserted, @removed = 0
  </code></pre>
  
  <p>Many thanks</p>