title: Set Variable for Select Result in SQL Server
body: <p>I have SQL statement like these:</p>
  
  <pre><code>DECLARE @bDate DATE;
  SET @bDate = SELECT birth_date FROM person WHERE id='1';
  
  SELECT @bDate;
  </code></pre>
  
  <p>But the result always is an error:</p>
  
  <blockquote>
    <p>Must Declare the scalar variable for @bDate</p>
  </blockquote>
  
  <p>Can anyone help me? I have asked from any forum but the result are same. </p>
  
  <p>Thanks</p>