WITH in tsql v Standard
<p>Is <code>WITH</code> used in more places than just for <code>Common Table Expressions</code> in either <code>tsql</code> or <code>Standard SQL</code> functionality?</p>

<p>Reason I ask is that I'd like to know what the reason is that a semi-colon is enforced in the statement before a <code>CTE</code>s <code>WITH</code>. </p>

<p>I'm assuming that the semi-colon is to help the parser, especially if <code>WITH</code> is used in more than one context, or if they are planning on using it in more than one context.</p>