title: using "USE" keyword Vs. full table name in T-SQL
body: <p>When I want to select from table Y in database X I can use</p>
  
  <pre><code>select * from [X].[dbo].[Y]
  </code></pre>
  
  <p>or</p>
  
  <pre><code>USE X
  select * from [Y]
  </code></pre>
  
  <p>Is there any reason to prefer one over the other?</p>