this describes the user defined functions in sql server and oracle like scalar valued functions, table valued functions.
Read this post on handyinsight.com