Tuesday, July 5, 2011

Can you use try..catch block in user defined functions ?

NO.

http://msdn.microsoft.com/en-us/library/ms175976.aspx
The TRY…CATCH construct cannot be used in a user-defined function.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

rls

To enable row-level security (RLS) in MS SQL Server (2016 and later) , you need to define a security policy that uses a user-defined, inli...