Do not indent BEGIN END
已回答
Current:
IF 1 = 1
BEGIN
SELECT 1
END
Should be:
IF 1 = 1
BEGIN
SELECT 1
END
Also DO NOT indent 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
请先登录再写评论。
Hello,
Which SQL dialect do you use?