Firebird 2.5 Language Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 6.1.2. The SELECT Columns List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365 8.10.3. LIST(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . because ADD is both a keyword and a reserved word. CREATE TABLE T (ADD INT NOT NULL); Refer to the list of reserved words and keywords in the chapter Reserved Words and Keywords. 2.3. Identifiers All0 码力 | 521 页 | 2.30 MB | 1 年前3- firebird 40 language reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 254 6.1.2. The SELECT Columns List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 9.2.3. LIST(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . because ADD is both a keyword and a reserved word. CREATE TABLE T (ADD INT NOT NULL); Refer to the list of reserved words and keywords in the chapter Reserved Words and Keywords. Chapter 2. SQL Language0 码力 | 778 页 | 3.43 MB | 1 年前3
- firebird language reference 30 rus............................................................................................. 459 LIST ................................................................................................. Доступно в: DSQL, PSQL, ESQL. Синтаксис:
[NOT] IN ( | [, ...] подзапроса может содержать только один столбец, иначе будет выдана ошибка «count of column list and variable list do not match». Запросы с использованием предиката IN с подзапросом, можно переписать на 0 码力 | 719 页 | 3.98 MB | 1 年前3 - Firebird Null Guide: NULL behaviour and pitfalls in Firebird SQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 5.1.1. With an empty list . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.1.3. With NULLs in the list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . is done with the ‘=’ operator, just like assigning values. You can also include NULL in an insert list or use it as input parameter to a stored procedure (both are special types of assignments). if (0 码力 | 69 页 | 479.63 KB | 1 年前3
- firebird isql. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 18.11. SET LIST. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . an example of what happens when you attempt to start isql with an invalid switch — it displays the list of valid switches with a brief explanation of each. $ isql --help Unknown switch: -help usage: -- return output to stdout SET0 码力 | 76 页 | 369.92 KB | 1 年前3
- firebird 30 sprachreferenz. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 459 9.1.3. LIST(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 IN Verfügbar in DSQL, PSQL, ESQL Syntax
[NOT] IN ( | [, …] Das Prädikat IN prüft, ob der Wert des Ausdrucks auf der linken Unterabfrage darf nur eine Spalte abfragen, andernfalls wird es zum Fehler “count of column list and variable list do not match” kommen. Abfragen, die das Prädikat IN mit einer Unterabfrage verwenden, können 0 码力 | 701 页 | 3.12 MB | 1 年前3 - Firebird 2.5 LangRef Update RussianFROM NEXT VALUE FOR SIMILAR TO Создание регулярных выражений SOME 13. Агрегатные функции LIST() MAX() MIN() 14. Встроенные функции ABS() ACOS() ASCII_CHAR() 7 Руководство по языку SQL SIMLAR TO: регулярные выражения Агрегатные функции Изменения начиная с Firebird 2.1: • Оператор LIST() может содержать любой текстовый разделитель Встроенные функции Изменения начиная с Firebird DIFFERENCE EXP FIRST FIRSTNAME FLOOR GEN_UUID GENERATED GRANTED HASH IIF INSERTING LAST LASTNAME LEAVE LIST LN LOCK LOG LOG10 LPAD MAPPING MATCHED MATCHING MAXVALUE MIDDLENAME MILLISECOND MINVALUE MOD NEXT0 码力 | 364 页 | 1.45 MB | 1 年前3
- Firebird 2.1 ErrorCodesdsql_derived_table_more_columns Column list from derived table @1 has more columns than the number of items in its SELECT statement -104 336397219 dsql_derived_table_less_columns Column list from derived table @1 has name for view select expression -158 335544599 num_field_err Number of columns does not match select list -162 335544685 no_dbkey Dbkey not available for multi-table views -170 335544512 prcmismat Input one base table -283 335544639 stream_not_found Table @1 is referenced in the plan but not the from list -284 335544642 index_unused Index @1 cannot be used in the specified plan -291 335544531 primary_key_notnull0 码力 | 31 页 | 103.24 KB | 1 年前3
- firebird gfixthe old method in which you had to supply an invalid switch (such as -help) in order to see the list of valid ones. Firebird 2.5 onwards. -fe[tch_password]
| stdin | /dev/tty databases linux@my_employee and remote:testlimbo. Both of these database names are aliases. linux> gfix -list my_employee Transaction 67 is in limbo. Multidatabase transaction: Host Site: linux Transaction would be: gfix -l[ist] -pr[ompt] database_name An example of this is shown below. linux> gfix -list -prompt my_employee Transaction 67 is in limbo. Multidatabase transaction: Host Site: linux Transaction 0 码力 | 44 页 | 247.13 KB | 1 年前3 - Firebird 2.1.5 Installationat all. New Reserved Words (Keywords) A number of new reserved keywords are introduced. The full list is available in a chapter of its own in the accompanying Release Notes and also in Firebird's CVS to by the “ordinal number” (degree) in an ORDER BY clause, when the output list uses SELECT * FROM ... syntax, the column list will be expanded and taken into account when determining which column the seems to have gone wrong 4. you know to go to the Firebird lists index to find a suitable support list if you encounter a problem. • Provided you do not have a FIREBIRD environment variable defined, the0 码力 | 46 页 | 217.89 KB | 1 年前3
共 28 条
- 1
- 2
- 3