CFUNITED Session: Advanced SQL

 
Jul 01, 2005
Presenter: Selene Bainum

Reviewed by Sheila Handler, JDT Technologies, Ltd.

This was a good, clear overview of some advanced SQL items, such as conditional programming, stored procedures, triggers, cursors, and custom functions.

I didn't learn much, but I've just started using cursors a lot and liked hearing about them. I never heard of, or used, SQL custom functions; they sound like a good idea. I wasn't aware of the difference beween Len and DataLen functions (the first does not include trailing blanks in the len). I was also unaware that SQL has a break and continue verb for getting out of loops.
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting