Try...Catch có dùng được trong SQL Server functions??

Try.. Catch..

Can we implement Try/Catch blocks inside Use Defined Functions(UDF)?

Choose your answer: Yes No

Correct answer: No
Explanation: You will get the error: Invalid use of a side-effecting operator 'BEGIN TRY'/ 'END TRY' / 'BEGIN CATCH'/ 'END CATCH' within a function. You cannot use try..catch inside of a UDF.

Ref: Try..Catch - http://msdn.microsoft.com/en-us/library/ms175976.aspx