title: Using System Environment variables in a sql script
body: <p>In a SQL script</p>
  
  <pre><code>GO
  :setvar DefaultDataPath "%DataDrive%:\SQL\MSSQL\Data"
  </code></pre>
  
  <p>Will the script pick up %DataDrive% from the environment variables?
  If not, is there a way to get to the DataDrive environment variable from the SQL script?</p>