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

Latest

Friday, December 6, 2019

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




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.