User Defined Functions in SQL : Scalar, Inline Table-Valued, Multi Statement

Hola Friends! Today we will learn about various user defined functions present in SQL. So far, we have studied lots of system functions : IsDate, Rand(), round() etc. To gather more information about these system functions, please refer my post Mathematical functions in SQL and Date time functions in SQL.

SQL provides us a feature of programmability wherein it provides system functions as well as lets user create functions of three types:

  1. Scalar functions
  2. InLine Table Valued functions
  3. Multi Statement table valued functions

Each type of sql function is of different use and one should have a proper understanding of all these function types.

If you are new to SQL, please check SQL basics and SQL mathematical

 functions.

One thought on “User Defined Functions in SQL : Scalar, Inline Table-Valued, Multi Statement”

  1. Wonderful work! That is the type of info that are supposed to be shared across the net.
    Disgrace on the search engines for not positioning this
    put up higher! Come on over and discuss with my website .

    Thanks =)

Leave a Reply

Your email address will not be published. Required fields are marked *