title: Store on single result from query into a variable in SQL
body: <p>I have this table:</p>
  
  <pre><code>id     Name              Age 
  ------ ----------------- ----
  10015  Phill             12
  10016  Anne              14
  </code></pre>
  
  <p>I need only the Phill´s age. So I do:</p>
  
  <pre><code>SELECT Age FROM Persons WHERE id = 10015
  </code></pre>
  
  <p>But I need to save that information into a variable.</p>
  
  <p>If I do this:</p>
  
  <pre><code>DECLARE @age Int
  SET @age = SELECT Age FROM Persons WHERE Name LIKE 'Phill'
  </code></pre>
  
  <p>I get this <i>error</i>:</p>
  
  <pre><code>Incorrect syntax near the keyword 'SELECT'.
  </code></pre>