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