sql-2003-2.bnf.html

sql 2003的 bnf范式

<p><a name="identifier part"> &nbsp; </a>
<a href="#xref-identifier part"> &lt;identifier part&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#identifier start'>&lt;identifier start&gt;</a>  |  <a href='#identifier extend'>&lt;identifier extend&gt;</a>

<p>
<i>
<small>
Previous standard said:
<br>
<p><a name="identifier start"> &nbsp; </a>
<a href="#xref-identifier start"> &lt;identifier start&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#initial alphabetic character'>&lt;initial alphabetic character&gt;</a>  |  <a href='#ideographic character'>&lt;ideographic character&gt;</a>
</small>
</i>
</p>

<p><a name="identifier start"> &nbsp; </a>
<a href="#xref-identifier start"> &lt;identifier start&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax Rules </font>

<p><a name="identifier extend"> &nbsp; </a>
<a href="#xref-identifier extend"> &lt;identifier extend&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax Rules </font>

<p><a name="large object length token"> &nbsp; </a>
<a href="#xref-large object length token"> &lt;large object length token&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#digit'>&lt;digit&gt;</a> ...  <a href='#multiplier'>&lt;multiplier&gt;</a>

<p><a name="multiplier"> &nbsp; </a>
<a href="#xref-multiplier"> &lt;multiplier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#xref-K"> K </a>  |  <a href="#xref-M"> M </a>  |  <a href="#xref-G"> G </a>

<p>
<i>
<small>
The productions for &lt;Unicode delimited identifier&gt; and so on are new in SQL-2003.
</small>
</i>
</p>

<p><a name="Unicode delimited identifier"> &nbsp; </a>
<a href="#xref-Unicode delimited identifier"> &lt;Unicode delimited identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#xref-U"> U </a> <a href='#ampersand'>&lt;ampersand&gt;</a> <a href='#double quote'>&lt;double quote&gt;</a>  <a href='#Unicode delimiter body'>&lt;Unicode delimiter body&gt;</a> ...  <a href='#double quote'>&lt;double quote&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [  <a href="#xref-ESCAPE"> ESCAPE </a>  <a href='#escape character'>&lt;escape character&gt;</a>  ]
<p><a name="Unicode delimiter body"> &nbsp; </a>
<a href="#xref-Unicode delimiter body"> &lt;Unicode delimiter body&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#Unicode identifier part'>&lt;Unicode identifier part&gt;</a> ...

<p><a name="Unicode identifier part"> &nbsp; </a>
<a href="#xref-Unicode identifier part"> &lt;Unicode identifier part&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#delimited identifier part'>&lt;delimited identifier part&gt;</a>  |  <a href='#Unicode escape value'>&lt;Unicode escape value&gt;</a>

<p><a name="Unicode escape value"> &nbsp; </a>
<a href="#xref-Unicode escape value"> &lt;Unicode escape value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#Unicode 4 digit escape value'>&lt;Unicode 4 digit escape value&gt;</a>  |  <a href='#Unicode 6 digit escape value'>&lt;Unicode 6 digit escape value&gt;</a>

<p><a name="Unicode 4 digit escape value"> &nbsp; </a>
<a href="#xref-Unicode 4 digit escape value"> &lt;Unicode 4 digit escape value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#escape character'>&lt;escape character&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a>

<p><a name="Unicode 6 digit escape value"> &nbsp; </a>
<a href="#xref-Unicode 6 digit escape value"> &lt;Unicode 6 digit escape value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#escape character'>&lt;escape character&gt;</a>  <a href='#plus sign'>&lt;plus sign&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a> <a href='#hexit'>&lt;hexit&gt;</a>

<p><a name="escape character"> &nbsp; </a>
<a href="#xref-escape character"> &lt;escape character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax Rules </font>

<p><a name="nondoublequote character"> &nbsp; </a>
<a href="#xref-nondoublequote character"> &lt;nondoublequote character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the Syntax Rules </font>

<p>
<i>
<small>
The rule for &lt;doublequote symbol&gt; in the standard uses two adjacent literal double quotes rather than referencing &lt;double quote&gt;; the reasons are not clear.
It is annotated '!! two consecutive double quote characters'.
</small>
</i>
</p>

<p><a name="doublequote symbol"> &nbsp; </a>
<a href="#xref-doublequote symbol"> &lt;doublequote symbol&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href='#double quote'>&lt;double quote&gt;</a>  <a href='#double quote'>&lt;double quote&gt;</a>

<p><a name="delimiter token"> &nbsp; </a>
<a href="#xref-delimiter token"> &lt;delimiter token&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href='#character string literal'>&lt;character string literal&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#date string'>&lt;date string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#time string'>&lt;time string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#timestamp string'>&lt;timestamp string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#interval string'>&lt;interval string&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#delimited identifier'>&lt;delimited identifier&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#Unicode delimited identifier'>&lt;Unicode delimited identifier&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#SQL special character'>&lt;SQL special character&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#not equals operator'>&lt;not equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#greater than or equals operator'>&lt;greater than or equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#less than or equals operator'>&lt;less than or equals operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#concatenation operator'>&lt;concatenation operator&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#right arrow'>&lt;right arrow&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#left bracket trigraph'>&lt;left bracket trigraph&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#right bracket trigraph'>&lt;right bracket trigraph&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#double colon'>&lt;double colon&gt;</a><br>&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; <a href='#double period'>&lt;double period&gt;</a>
<p>
<i>
<small>
The rules for &lt;not equals operator&gt; etc in the standard uses
two adjacent literal characters rather than referencing
&lt;less than&gt; and &lt;greater than&gt;; the reasons are not clear.
Note that two characters must be adjacent with no
intervening space, not a pair of characters separated by
arbitrary white space.
</small>
</i>
</p>