The BREAK Keyword in Transact SQL
Category:
tsql-programming
BREAK is a useful piece of control-of-flow language in SQL Server, but it only works in specific situations.
Tag: control-of-flow
Using RETURN in Transact SQL: Quiz Results
Category:
tsql-programming
RETURN is a “control of flow” language keyword in Transact-SQL. It’s very useful for managing when code does – and does NOT – get executed in procedural code, and it can also be used to communicate the status from procedural code.
But not everyone knows how to use RETURN, and learning about it can be awkward because of some quirks of SQL Server Management Studio. It is well worth taking the time to get used to it, though!