title: How to store result of a select statement into a variable?
body: <p>I tried with the below code: </p>
  
  <pre><code>DECLARE @rec_count     int
  Set @rec_count=  select 1
  </code></pre>
  
  <p>but it shows error </p>
  
  <blockquote>
    <p>"Incorrect syntax near Select".</p>
  </blockquote>