CODE EXAMPLE FOR SQL

sub blocks in sql

stored procedure -- precompiled, with or without parameters
stored function -- 2 types: scalar valued, table valued