August 8, 2011

User Defined functions in SQL Server

There are three types of user defined functions in SQL Server.

1.Scalar User Defined Function
2.Inline Table Value User Defined Function
3.Multi Statement User Defined Function


Scalar User Defined Function

A Scalar user defined function always returns single value.It takes 0 to many parameter.

No comments:

Post a Comment