Which of the following is not a limitation of user defined function?

Question

TuteeHUB · Accepted Answer

The FOR XML clause is not allowed

TuteeHUB · Answer

User-defined functions cannot call a stored procedure, but can call an extended stored procedure

TuteeHUB · Answer

User-defined functions cannot make use of dynamic SQL or temp tables. Table variables are allowed

TuteeHUB · Answer

SET statements are allowed in a user-defined function

1.	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» D. The FOR XML clause is not allowed

Discussion