Which of the following is most visible benefit of user-defined function ?
A. Slow performance
B. Bad optimized queries
C. Faster performance
D. All of the mentioned
Answer:A
Which of the following is most visible benefit of user-defined function ?
A. Slow performance B. Bad optimized queries C. Faster performance D. All of the mentioned
Explanation:T-SQL functions are great at processing data. When it comes to business logic and custom algorithms, UDFs can do a much better job. UDFs work akin to stored procedures.