title: How can I set a BIT variable based on a value variable?
body: <p>I have:</p>
  
  <pre><code>DECLARE @Authenticated BIT
  
  If @@ROWCOUNT &gt; 0
   begin
     SELECT @Authenticated = 1
   end ELSE
   begin
     SELECT @Authenticated = 0
   end 
  </code></pre>
  
  <p>Is there a way I could do this without the BEGIN END and also is setting a BIT datatype a good way to represent True of False?</p>