When your Database contains a EVENT of type DatabaseStart and you are able to crash the Database Engine during startup with your fabulous code. How would you fix the database to …

Please implement a DatabaseStartFailed event that gets control when the engine is in the process of failing to fully start a database because of some startup error. This event shou …

How many times have you wanted to code something like this? DECLARE @upgrade_ok VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' CHECK ( @upgrade_ok IN ( 'Y', 'N' ) ); …

How do I import data from a file while skipping existing rows? Once in a while I have to import data from a file into a table, where some rows may already exists (row with same pr …

When i need to validate user input in fields it is often necessary to make sure only a limited set of characters is used. Example could be European VAT Numbers, Phone, Container …

I'd like to see records added to the stored procedure language of SQA. One of the biggest complaints from my developers when moving code from Oracle to SQLA is the lack of records …

Another Oracle feature that I would like see added to is some sort of collections in the procedure language. The ability to have arrays at a minimum would be very beneficial. Ora …