SQL Server Functions Interview Question:

What is user-defined function? Explain its types i.e. scalar and Inline table value user-defined function?

Submitted by: Administrator

User defined functions are created and defined by the user. They are created as per users needs. They may or may not accept parameters. They can be used to create joins and simple to invoke as compared to stored procedures

Types:
Scalar user defined: returns values as one of the scalar data types. Text, timestamp, image data types are not supported. It may or may not accept parameters.

Inline table value user defined : it returns a table data type. These functions can pass parameters to the sql's SELECT command. They are similar to views except, they can accept parameters.
Submitted by: Administrator