Question

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

This question was addressed to me in an internship interview.

I want to ask this question from User Defined Functions topic in portion Developing with SQL Server of SQL Server

Answer 1

Right answer is (d) All of the mentioned

For 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.