COMMON Fall Conference & Expo

SQL is much more than a query language. Besides querying and manipulating data in database objects and generating those database objects, SQL also provides all kinds of commands and constructs, for writing and executing programs. With the SQL Programming Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written, without knowing anything else than SQL commands! This session will give you an introduction into the SQL Programming Language. The procedure and function create options and controls are explained. You’ll learn how to structure the source code within the routine body, how to define variables and cursors, what control statements are available, how to read data row by row in a loop, how to receive and return parameter values and result sets and how to handle errors. Besides the pure coding you’ll get also a short introduction into the development tools.