- FOR REPLICATION option
- EXTERNAL NAME ( external methods)
- ENCRYPTION option
Insert into @vExcelFileList
You might want to enable ad hoc query options;
We can make use of transactions and roll back transactipon in the CATCH block. The TRY...CATCH construct also supports additional system functions (ERROR_LINE, ERROR_MESSAGE, ERROR_PROCEDURE, ERROR_SEVERITY, and ERROR_STATE) that return more error information than @@ERROR. TRY...CATCH also supports an ERROR_NUMBER function that is not limited to returning the error number in the statement immediately after the statement that generated an error.
Now, in SQL Server 2012, we can also use THROW to throw the exception to the application. You can say it works like RAISERROR;
You can use THROW statement like RAISERROR as well;