分享方式:


SQL 語句中使用的元素

下列元素會用於先前所列的 SQL 語句中。

元素

base-table-identifier ::= user-defined-name

base-table-name ::= base-table-identifier

boolean-factor ::= [NOT] boolean-primary

boolean-primary ::= comparison-predicate |( 搜尋條件

boolean-term ::= boolean-factor [AND boolean-term ]

character-string-literal ::= ''{ character }...'' ( character 是驅動程式/資料來源字元集中的任何字元。 若要在 character-string-literal 中包含單一常值引號字元 ('''),請使用兩個常值引號字元 ['''']。

column-identifier ::= user-defined-name

column-name ::= [ table-name .] column-identifier

comparison-operator ::= < | | <>= |>= | = |<>

comparison-predicate ::= 運算式 comparison-operator expression

data-type ::= character-string-type ( character-string-type 是 SQLGetTypeInfo 所傳回結果集中 「」DATA_TYPE「」 資料行為SQL_CHAR或SQL_VARCHAR的任何資料類型。

digit ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

dynamic-parameter ::= ?

運算式 ::= term | expression {+|-} term

factor ::= [ +|- ] primary

insert-value ::=

dynamic-parameter

| literal

| NULL

|使用者

letter ::= lower-case-letter | upper-case-letter

literal ::= character-string-literal

lower-case-letter ::= a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z

order-by-clause ::= ORDER BY sort-specification [, sort-specification ]...

primary ::= column-name

| dynamic-parameter

| literal

|( 運算式

search-condition ::= boolean-term [OR search-condition ]

select-list ::= * | select-sublist [, select-sublist ]...( select-list 不能包含參數。)

select-sublist ::= expression

sort-specification ::= { unsigned-integer | column-name } [ ASC |DESC ]

table-identifier ::= user-defined-name

table-name ::= table-identifier

table-reference ::= table-name

table-reference-list ::= table-reference [, table-reference ]...

term ::= factor | term {*| / } 因素

unsigned-integer ::= { digit }

upper-case-letter ::= A |B |C |D |E |F |G |H |I |J |K |L |M |N |O |P |Q |R |S |T |U |V |W |X |Y |Z

user-defined-name ::= letter[ digit | letter | _ ]...