SQL Server Functions Question: Download MS SQL Server Functions PDF
What is user-defined function? Explain its types i.e. scalar and Inline table value user-defined function?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain the benefits of User-Defined Functions? | What is built-in function? |