Don't indent BEGIN/END bloc after AS in function/procedure definition
CREATE FUNCTION MyFunc()
RETURNS INT
AS
BEGIN
----IF 1=1
--------BEGIN
------------<some code>
--------END
END
END
1
vote
This should already be an option in SQL Prompt under Format→Schema statements→Indent contents.
-
Aaron Brindell commented
(Whoops, extra END at the end. Ignore the second one.)