SQL Server Functions Question:
Download Job Interview Questions and Answers PDF
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.
Download MS SQL Server Functions Interview Questions And Answers
PDF
| 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? |