. . . . . . . . . . 54 17.1. Testing for NULL — if it matters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 17.2. Equality tests Jack NULL 3 Jim 5 4 Joe 12 5 Josh NULL ...the statement select sum(Amount) from MyTable returns 54, which is 37 + 5 + 12. Had all five fields been summed, the result would have been NULL. For AVG, Adventures table Name Bought Price Maniac Mansion 12-Jun-1995 $ 49,-- Zak McKracken 9-Oct-1995 $ 54,95 You have already entered some adventure games in this table when you decide to add a non- nullable

......................................... 54 Пользовательские типы данных — домены ........................................................................ 54 Атрибуты домена ......................... TIMESTAMP); См. также: Явное преобразование типов данных. Типы данных 54 Неявное преобразование типов данных В 3-м диалекте невозможно неявное преобразование данных, здесь user-defined exception Необработанное исключение, определенное пользователем SQLCLASS 54 (Program Limit Exceeded) Класс ошибок 54 (превышены ограничения программы) 54000 Program limit exceeded Превышены ограничения

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 19. Isql Show commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Baldwin 105 Bender 28 Bennet 83 Bishop 109 Brown Chapter 18. Isql Set Commands 54 EMP_NO is a smallint data type. Unfortunately, it doesn’t appear to be possible to change the width

The remaining files in the database have this field set to zero. hdr_misc Twelve bytes. Bytes 0x54 - 0x5f on the page. Set to zero. These 12 bytes are currently unused. The following is an example not a defined page type and, doesn’t appear in RDB$PAGES. Chapter 12. Generator Page — Type 0x09 54 SQL> SELECT * CON> FROM RDB$PAGES CON> WHERE RDB$PAGE_TYPE = 9 CON> OR RDB$PAGE_NUMBER = 257; RDB$PAGE_NUMBER

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 4.1.3. Conditional Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . evaluated from left to right. To force a different evaluation Chapter 4. Common Language Elements 54 order, operations can be grouped by means of parentheses. Table 12. Operator Type Precedence Operator 5. Data Definition (DDL) Statements 173 DSQL, ESQL Syntax DROP EXCEPTION exception_name Table 54. DROP EXCEPTION Statement Parameter Parameter Description exception_name Exception name The statement

37 2 Jack 3 Joe 5 4 Josh 12 5 Jay ...выражение select sum(Amount) from MyTable вернет 54, что получается из 37 + 5 + 12. Если бы все пять значений полей были просуммированы, в результате должен

3 Andrés 5 4 Roberto 12 5 Antonio ...la sentencia select sum(Sueldo) from MiTabla devuelve 54, que es 37+5+12. Si sumáramos todos los valores, el resultado debería haber sido NULL. Para AVG, los

Jack 3 Joe 5 4 Josh 12 5 Jay ...l'instruction select sum(Amount) from MyTable renvoie 54, qui est 37 + 5 + 12. Si les cinq champs avaient été additionnés, le résultat aurait été NULL. Pour

not supported. See also FILTER, DECLARE FILTER, BLOB_APPEND() Chapter 3. Data Types and Subtypes 54 3.8. Array Types  Firebird does not offer much in the way of language or tools for working with EXTERNAL FUNCTION funcname [ENTRY_POINT 'new_entry_point'] [MODULE_NAME 'new_library_name'] Table 54. ALTER EXTERNAL FUNCTION Statement Parameters Parameter Description funcname Function name in the Violation SQLCLASS 45 (Unhandled User-defined Exception) 45000 Unhandled user-defined exception SQLCLASS 54 (Program Limit Exceeded) 54000 Program limit exceeded 54001 Statement too complex 54011 Too many

sofern sie nicht von anderen Datenbankobjekten verwendet wird. Chapter 3. Datentypen und Untertypen 54 Syntax DROP DOMAIN name  Jeder mit der Datenbank verbundene Benutzer kann eine Domäne löschen. 'BLOB'-Filterdeklaration aus der Datenbank Verfügbar in DSQL, ESQL Syntax DROP FILTER filtername Tabelle 54. DROP FILTER-Anweisungsparameter Parameter Beschreibung filtername Filtername in der Datenbank Die Violation SQLCLASS 45 (Unhandled User-defined Exception) 45000 Unhandled user-defined exception SQLCLASS 54 (Program Limit Exceeded) 54000 Program limit exceeded 54001 Statement too complex 54011 Too many