title: Relative path in t sql?
body: <p>How to get the relative path in t sql? Take for example a <code>.sql</code> file is located in the folder <code>D:\temp</code>, I want to get path of the file hello.txt in the folder  <code>D:\temp\App_Data</code>. How to use the relative path reference?</p>
  <p>Let's say I am executing the sql file inside the SQL server management studio.</p>