Show Menu
Cheatography
  1. Home >
  2. Programming >

SQL Server - Error Manager Cheat Sheet (DRAFT) by

SQL Server - Error Manager

This is a draft cheat sheet. It is a work in progress and is not finished yet.

BLOQUES RELACI­ONADOS

BEGIN TRY ... END TRY
BEGIN CATCH ... END CATCH
BEGIN TRANSA­CTION [COMMIT TRANSA­CTION | ROLLBACK TRANSA­CTION] END TRANSA­CTION
THROW [error­_nu­mer­o],­[er­ror­_me­nsa­je]­,[e­rro­r_e­stado]
THROW [ { error_­number | @local­_va­riable }, { message | @local­_va­riable }, { state | @local­_va­riable } ] [ ; ]
 

ERROR FUNCTIONS

ERROR_­NUM­BER()
ERROR_­SEV­ERITY()
ERROR_­STATE()
ERROR_­PRO­CED­URE()
ERROR_­MES­SAGE()
ERROR_­LINE()
IMPORTANTE !!! solo aplica al ultimo error lanzado.