Point out the correct statement :
A. User-defined functions cannot be used to perform actions that modify the database state.
B. User-defined functions cannot contain an OUTPUT INTO clause that has a table as its target.
C. User-defined functions can not return multiple result sets. Use a stored procedure if you need to return multiple result sets.
D. All of the mentioned
Answer:A
Point out the correct statement :
A. User-defined functions cannot be used to perform actions that modify the database state. B. User-defined functions cannot contain an OUTPUT INTO clause that has a table as its target. C. User-defined functions can not return multiple result sets. Use a stored procedure if you need to return multiple result sets. D. All of the mentioned
Explanation:Transact-SQL errors that cause a statement to be canceled and continue with the next statement in the module (such as triggers or stored procedures) are treated differently inside a function.