SQL Server Functions Question:
Explain the benefits of User-Defined Functions?
Answer:
a. Can be used in a number of places without restrictions as compared to stored procedures.
b. Code can be made less complex and easier to write.
c. Parameters can be passed to the function.
d. They can be used to create joins and also be sued in a select, where or case statement.
e. Simpler to invoke.
b. Code can be made less complex and easier to write.
c. Parameters can be passed to the function.
d. They can be used to create joins and also be sued in a select, where or case statement.
e. Simpler to invoke.
| Previous Question | Next Question |
| MS SQL Server Functions Job Interview Questions! | What is user-defined function? Explain its types i.e. scalar and Inline table value user-defined function? |