| Sort by:
|
Page 5 of 5 | Previous | 1 2 3 4 5
|
|
|
24 Jul 2000
|
Querying for the time portion of a Datetime field
A couple different alternatives for querying for a time.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Does InterBase use indexes with MIN and MAX
Indexes do not get used unless you have Interbase 5.0 or later
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
One method for making a table appear "read only"
Only GRANT SELECT priviliges to the table.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to determine if a set of columns have unique values for rows in a table
You can run a query to see if there duplicates
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Trying to group by a UDF return value
Grouping is only allowed field values stored in a table
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to copy a record from one table to another using SQL
You can copy a record from one table to another using an INSERT statement
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
What are the acceptable formats for inserting into date fields
11 different acceptable date formats
|
Quinn Wildman
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How do I select the system date
select cast('today' as date) from rdb$database
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to determine the datatype for a constant?
How to determine the datatype for a constant?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Does InterBase support DATE literals, if yes how do I use them?
Does InterBase support DATE literals, if yes how do I use them?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
What does the privilege REFERENCES allow you to do?
What does the privilege REFERENCES allow you to do?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Trigger doesn't fire
My after insert trigger doesn't fire?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How can I lock a record in InterBase?
UPDATE, DELETE or INSERT will lock the records at the time these operations are done on the records.
|
Borland Staff
|
FAQ
|
|
|
|
|
18 Jan 1993
|
What is a query plan and what can I do with it?
Specifying Query Access Plans in the InterBase Optimizer
|
Borland Staff
|
TI
|
|
|
Connect with Us