SQL


Articles

Sort by: Page 4 of 5 | Previous | 1 2 3 4 5 | Next
DateTitleAuthorType
24 Jul 2000 What is the SQL-equivalent of GDML's FIRST clause
There is no single SQL command that replaces the FIRST clause
Borland Staff FAQ
24 Jul 2000 What is the equivalent of the GDML 'MISSING' keyword in SQL?
The 'Missing' keyword in GDML is equivalent to 'Null' in SQL.
Borland Staff FAQ
24 Jul 2000 Getting gds_free & gds_alloc errors
Problem resolved in InterBase 5.0
Borland Staff FAQ
24 Jul 2000 An example of foreign key referencing self table
Example of a straight where field2 is contained in field1
Borland Staff FAQ
24 Jul 2000 How to calculate the age from a date field
A computed column can show the age
Borland Staff FAQ
24 Jul 2000 How to add not null to an existing column
What is the ALTER TABLE syntax to add a not null constraint to a column?
Borland Staff FAQ
24 Jul 2000 Listing column names in an InterBase table
What is the SQL command to get the column names for a specific table in an InterBase database?
Borland Staff FAQ
24 Jul 2000 invalid request BLR at offset 13369
Getting the following error while trying to compile a stored procedure script "invalid request BLR at offset 13369 -context not defined (BLR error) "
Borland Staff FAQ
24 Jul 2000 FOR SELECT --- DO Example
Important items to check when using a "for select -- do"
Borland Staff FAQ
24 Jul 2000 Ability to create a database using the API call
API call "isc_dsql_execute_immediate()" may set you databse habdles to NULL
Borland Staff FAQ
24 Jul 2000 Dynamic SQL Error: Token unknown
InterBase version 4.0 and onwards, is pretty strict about the usage of reserved words in any SQL statements..
Borland Staff FAQ
24 Jul 2000 Information on how to use the dow() UDF
Getting the error .."error 171: function dow() could not be matched..
Borland Staff FAQ
24 Jul 2000 Display of sort info on Query Plan
The optimizer does consider the cost of sorts
Borland Staff FAQ
24 Jul 2000 Inserting and Updating through a view - no triggers involved
SQL examples of updating a view.
Borland Staff FAQ
24 Jul 2000 Select distinct doesn't return correct row count
Using a plan or creating an index fix the problem
Borland Staff FAQ
24 Jul 2000 Do changes in the table's definition propagate the changes to the view?
Changes in the table do not propogate to views that use the table.
Borland Staff FAQ
24 Jul 2000 How to Concatenate Strings in InterBase
|| is the concatenation operator
Borland Staff FAQ
24 Jul 2000 How to prevent users from creating tables
Remove the D from the license file on the server or periodically delete them.
Borland Staff FAQ
24 Jul 2000 A Possible Cause of "Token Unknown SQL code 104" Errors When Creating Tables
THis error uccurs if you use a keyword as a table name.
Borland Staff FAQ
24 Jul 2000 Multiple rows in singleton select occurs when attempting an update
This error occurs if a subquery returns more than one rows in an UPDATE statement.
Borland Staff FAQ

Server Response from: ETNASC02