T-SQL language elements: control of flow, errors, and transactions

 

Allow  you o control the flow of execution within code, handle errors, and maintain transactions
Used in programmatic code objects
   Stored procedures, triggers, statement blocks

Control of Flow	Error Handling	Transaction Control
IF...ELSE WHILE BREAK CONTINUE BEGIN...END	TRY...CATCH	BEGIN TRANSACTION COMMIT TRANSACTION ROLLBACK TRANSACTION