Do not intend BEGIN END

Current:

IF 1 = 1
  BEGIN
    SELECT 1
  END

Should be:

IF 1 = 1
BEGIN
  SELECT 1
END

Also DO NOT intend after BEGIN TRAN

Current

BEGIN TRAN T1
  DELETE FROM Users WHERE Id = 1
  DELETE FROM UserData WHERE Id = 1
COMMIT TRAN T1

Should be

BEGIN TRAN T1
DELETE FROM Users WHERE Id = 1
DELETE FROM UserData WHERE Id = 1
COMMIT TRAN T1

Please sign in to leave a comment.