Which of the following is not a limitation of user defined function ?
A. User-defined functions cannot call a stored procedure, but can call an extended stored procedure.
B. User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed.
C. SET statements are allowed in a user-defined function.
D. The FOR XML clause is not allowed
Answer:A
Which of the following is not a limitation of user defined function ?
A. User-defined functions cannot call a stored procedure, but can call an extended stored procedure. B. User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed. C. SET statements are allowed in a user-defined function. D. The FOR XML clause is not allowed
Explanation:SET statements are allowed in a user-defined function.