sentencias en SQL

Tipo Sentencias en SQL

WHILE:

WHILE...BEGIN...END
BREAK
CONTINUE

IF...ELSE:

IF...ELSE
BEGIN...END

CASE:

CASE
WHEN
ELSE
END

TRY...CATCH:

TRY...CATCH
BEGIN...END
THROW
CATCH

GOTO:

GOTO

WAITFOR:

WAITFOR
DELAY

SET:

SET
@@ERROR
@@ROWCOUNT
@@IDENTITY
@@TRANCOUNT