SQL
- Can I add a column and populate it in a single transaction?
- Can I do multi-database or cross-database queries with Firebird?
- Can I use IF in regular statements (not PSQL) ?
- Do I have to use UPPERCASE identifiers?
- Does Firebird support CLOB datatype?
- How do emulate INSERT IGNORE of MySQL?
- How to JOIN a table and selectable stored procedure?
- How to add a newline (CRLF) to the string from SQL?
- How to alter column from NULL to NOT NULL and vice versa?
- How to avoid having long GROUP BY list when joining other tables for data?
- How to break from a loop in PSQL?
- How to calculate days between two timestamps?
- How to calculate hours, minutes or seconds between two time values?
- How to change character column size?
- How to change column datatype when it has dependencies?
- How to convert 3 integer values into a date?
- How to convert BLOB to string?
- How to convert integer, decimal, double or date to string?
- How to convert string to number without getting any errors?
- How to create a for or while loop in stored procedure or trigger?
- How to create a table only if it does not exist?
- How to create an autoincrement column?
- How to delete duplicate records (when table doesn't have a primary key column)?
- How to delete or clear the external table?
- How to design a stored procedure whose parameters are determined run-time?
- How to determine which fields changed in an UPDATE trigger?
- How to do INSERT OR UPDATE depending of existence of primary key value?
- How to find active connections via SQL?
- How to find duplicate records?
- How to force Firebird to use a particular query PLAN?
- How to get record count for all tables?
- How to get record count for any query without executing it?
- How to get record number or rank as part of dataset?
- How to get the Firebird server date and time?
- How to get the last insert ID?
- How to get the timestamp of last record change?
- How to get the timestamp without milliseconds?
- How to group on calculation or calculated expression?
- How to insert multiple rows in a single statement?
- How to prevent Firebird from using an index in the query?
- How to reference column value in domain's check constraint?
- How to rename a database table?
- How to replace a part of string in char or varchar column?
- How to retrieve only a part of entire dataset (similar to LIMIT in MySQL)?
- How to run a select without table?
- How to send a list of numbers as a parameter to stored procedure?
- How to store current timestamp with milliseconds in a table column?
- How to supply a view, procedure or table name to a stored procedure?
- How to truncate a string to a certain number of characters?
- How to update multiple columns of one table using values from another table?
- Is it possible to use SELECT in COMPUTED columns?
- Is there a function like DUMP in Oracle?
- Is there a limit to SQL statement size?
- Is there a way to use trigger to stop INSERT, UPDATE or DELETE from happening?
- Is there an ENUM datatype in Firebird?
- Is there something like GROUP_CONCAT in Firebird?
- What is the resulting datatype of SUM over a decimal or numeric column?
- What's the Firebird equivallent of ADDDATE, GETDATE, etc. functions?
- What's the difference between CHAR and VARCHAR?
- What's the difference between LEFT, RIGHT, INNER, OUTER, JOIN?
- What's the difference between NO ACTION and RESTRICT?
- What's the difference between NUMERIC and DECIMAL
- When should the colon (:) character be used in procedure or trigger code?
- Which function to use to get the string length in Firebird?
- Why are BLOBs with same data treated as different?
- Why are NULLs not sorted?
- Why can't I extract date or time from timestamp?
- Why does CURRENT_TIMESTAMP return the same value for each row?
- Why does NULL + something or NULL * something give NULL result?
- Why does my stored procedure only return a single record?
- Why doesn't LIKE work with wildcard having % at the beginning?
- Why doesn't UNION of queries that return X and Y records return X+Y records?
- Why doesn't my AFTER INSERT trigger work?
- Why doesn't my EXECUTE BLOCK statement return records?
- Why is 'abc' equal to 'abc ' ?
- Why is 4/5 equal to zero?
- Why is FIRST not working properly in sub-selects?
- Why isn't my default value used?
- Why string + string doesn't work?
Copyright © 2007-2024 FirebirdFAQ.org
The Firebird FAQ