identifier can be a reserved word • Delimited identifiers are case-sensitive in all contexts • Trailing spaces in delimited names are removed, as with any string constant • Delimited identifiers are fixed-length character data type. When its data is displayed, trailing spaces are added to the string up to the specified length. Trailing spaces are not stored in the database but are restored to match two trailing bytes store the declared length. There is no default size: the n argument is mandatory. Leading and trailing spaces are stored and they are not trimmed, except for those trailing characters

identifier can be a reserved word • Delimited identifiers are case-sensitive in all contexts • Trailing spaces in delimited names are removed, as with any string constant • Delimited identifiers are default size: the n argument is mandatory. Leading and trailing NUL characters are stored, and they are not trimmed, except for those trailing characters that are past the declared length. VARCHAR(n) no default size: the n argument is mandatory. Leading and trailing spaces are stored, and they are not trimmed, except for those trailing characters that are past the declared length.  Note About

table has details of our employees.; The actual comment text is shown between the word 'IS' and the trailing semicolon. 19.4. SHOW DATABASE or SHOW DB SQL> SHOW {DATABASE | DB}; The show database (or show table name, it could be a function or procedure name, a sequence name etc. The output listed is a comma separated list of the other objects in the database upon which the supplied object is dependent.

SQL OPEN RECREATE RECURSIVE ROW_COUNT ROWS SAVEPOINT SENSITIVE SIMILAR SQLSTATE (2.5.1) START TRAILING TRIM Новые не зарезервированные ключевые слова Приведённые ниже слова добавлены в Firebird как Синтаксис: TRIM ([] str) ::= {[where] [what]} FROM where ::= BOTH | LEADING | TRAILING -- по умолчанию BOTH what ::= подстрока, которую надо удалить (неоднократно, если таких вхождений (LEADING '.' from ' Waste no space ') FROM RDB$DATABASE -- Результат: ' Waste no space ' SELECT TRIM (TRAILING '!' from 'Help!!!!') FROM RDB$DATABASE -- Результат: 'Help' SELECT TRIM ('la' FROM 'lalala I love

Синтаксис: TRIM ([] str) ::= {[] [what]} FROM ::= BOTH | LEADING | TRAILING функции TRIM Опция Описание BOTH с обеих сторон строки (по умолчанию) LEADING с начала строки TRAILING с конца строки Особенности использования: • Если входной параметр str имеет тип BLOB, то и результат (LEADING '.' FROM ' Waste no space ') FROM RDB$DATABASE -- Результат: ' Waste no space ' SELECT TRIM (TRAILING '!' FROM 'Help!!!!') FROM RDB$DATABASE -- Результат: 'Help' SELECT TRIM ('la' FROM 'lalala I love

Syntax TRIM ([] str) ::= {[] [what]} FROM ::= BOTH | LEADING | TRAILING Tabelle 156. TRIM-Funktionsparameter Parameter Beschreibung str Ein Ausdruck eines String-Typs String-Typs where Die Position, aus der der Teilstring entfernt werden soll — BOTH | LEADING | TRAILING. BOTH ist die Standardeinstellung what Die Teilzeichenfolge, die am Anfang, am Ende oder auf beiden Seiten ' from ' Waste no space ') from rdb$database -- Ergebnis ' Waste no space ' select trim (trailing '!' from 'Help!!!!') from rdb$database -- Ergebnis 'Help' select trim ('la' from 'lalala I love

recovered. Since Firebird 3.0, gbak tools has very useful option: -SKIP_D[ATA]. It allows to specify comma- separated list of tables to be skipped from the backup: gbak -b -skip_data country,currency l

non-NULL values in the column. This equals SUM(Field) / COUNT(Field). [1] LIST [2] NULL NULL Comma-separated string concatenation of non-NULL values in the column 8.1. The GROUP BY clause A GROUP