the fields, the remaining fields will be initialised to NULL except where a default value is in effect or a value is assigned by a “before insert” trigger. • If you add a column to a table that already often used in CHECK constraints. In that context, NULL expressions have a surprisingly different effect in Firebird versions 2.0 and up. This will be discussed in the section CHECK constraints. 5.2. search condition of a SELECT, UPDATE or DELETE statement resolves to NULL for a certain row, the effect is the same as if it had been false. Put another way: if the search expression is NULL, the condition

accept a literal like '2016-12-25 00:00:00.0000'. However, '2016-12-25' would have precisely the same effect, with fewer keystrokes! 3.4.2. TIME Syntax TIME [{ WITHOUT | WITH } TIME ZONE] For a bare TIME 12), carriage return (ASCII 13) and space (ASCII 32). Including a predefined class has the same effect as including all its members. Predefined classes are only allowed within class definitions. If you in the definition of a global temporary table GTTs are writable in read-only transactions. The effect is as follows: Read-only transaction in read-write database Writable in both ON COMMIT PRESERVE

accept a literal like '2016-12-25 00:00:00.0000'. However, '2016-12-25' would have precisely the same effect, with fewer keystrokes! 3.4.2. TIME The TIME data type is available in Dialect 3 only. It stores 69 carriage return (ASCII 13) and space (ASCII 32). Including a predefined class has the same effect as including all its members. Predefined classes are only allowed within class definitions. If you syntax of defining the table constraint correspond with those described for CREATE TABLE statement. Effect on Version Count • Each time a new column is added, the metadata change counter is increased by

may be abbreviated to letters in CAPitals If you attempt to drill down into any other command, the effect is exactly the same as executing the HELP command on its own.  In the output from HELP SET, there command. If set plan off had been executed, this command would have no effect, so turning planonly on has the additional effect of executing set plan on implicitly. Executing set planonly off does not displayed or not, when the selected data is a column defined with the DATE data type. It has no effect in other dialects. 18.21. SET TERM SQL> SET TERM new_terminator current_terminator This command

specify it when you use the alias to connect to the database. Aliases, once entered and saved, take effect immediately. There is no need to restart the server. Restrict database access The DatabaseAccess Windows user authenticated by the Win_Sspi plugin would be bob in every database. With the mapping in effect, the “Windows trusted” connection succeeds: SQL> connect xnet://employee; Database: xnet://employee

libraries ib_util.dll, fbudf.dll, ib_udf.dll, fbintl.dll are built without any embedded manifest. The effect is to avoid having the loader search for a MSVC8 assembly in the same folder as corresponding DLL that causes auto-updating (backup caching?) of all files on the system having a ".gdb" suffix. The effect is to slow down access to Firebird databases having that suffix to a virtual standstill as the files

management is in place to support this feature, the encryption is not going to achieve the desired effect. It may encourage you to believe you are protected, but you need to study the key management to

amply enough for any practical application. And since the number of generators you declare has no effect on performance, you can feel free to use as many generators as you like. Chapter 2. Generator Basics

synchronous mode (forced writes enabled) on Linux and all recent Windows versions. This command has no effect on Windows 95, 98 and ME.  Cache flushing on Windows servers (up to but not including Vista —

lot of work was done to address the international language issues, as you probably know. A side effect of this was that everything that was read from data and meta data became subject to "well-formedness"