How deeply does 100 SQL Server Mistakes and How to Avoid Them cover throw?

Positions THROW within TRY..CATCH and transaction cleanup, without detailing its syntax or rethrow semantics.

Throw

As explained in 100 SQL Server Mistakes and How to Avoid Them

THROW is a SQL Server statement that rethrows an original exception or raises a specified ad hoc error.

THROW raises a meaningful SQL Server error, either by rethrowing an error already caught or by issuing a specified ad hoc error. It belongs in deliberate error handling rather than as a substitute for cleaning up failed work. section 7.1 section 7.7

A failed statement inside a transaction can leave an open transaction behind if nothing rolls it back. Pair transaction handling with TRY..CATCH so failures are trapped, the transaction can be handled, and an error can be surfaced to the caller. section 7.1 section 7.7

Use THROW as part of a safer failure path:

Catch errors with TRY..CATCH rather than allowing failures to pass unmanaged. section 7.7
Roll back or otherwise resolve the transaction state before returning from failed transactional work. section 7.1
Raise a meaningful error message so an application or support process can identify and act on the failure. section 7.7

How 100 SQL Server Mistakes and How to Avoid Them covers it

Cover of 100 SQL Server Mistakes and How to Avoid Them

liveBook manning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

The Joy of JavaScriptA throw expression is an expression form that raises an exception from within an expression context.
liveBook manning.com

Practical Automation with PowerShell: Effective scripting from the console to the cloudA throw statement generates an exception or terminating error that interrupts normal PowerShell execution.

Compare how 3 books explain throw →

Related concepts

non-local returnaddresses · A non-local return is a control-flow transfer that exits an enclosing function or computation from within nested code.
exceptionkind of · An exception is a runtime signal or object representing an abnormal condition that interrupts ordinary program flow and may be handled or propagated.
RAISERRORalternative to · RAISERROR is a SQL Server statement or function for generating an error message with specified error information and severity behavior.
async iterableused by · An async iterable is an object that produces a sequence of values asynchronously through an asynchronous iteration protocol.
return statementcontrasts with · A return statement ends the current function or routine invocation and optionally supplies its result to the caller.
terminating errorproduces · A terminating error is an execution error that stops the current PowerShell operation or script unless it is handled.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.