Begin statement is not starting on a new line within an If statement. Please allow this in format styles. The option is there but it doesn't
When Place Begin - End statements on new line is selected it doesn't appear to work as part of an If statement. This makes the begin and end difficult to find
2
votes
Anonymous
shared this idea
-
Keith McCann
commented
All of mine do appear on a new line, so I don't know if maybe there's another option interfering for you. Here's an example from my formatted code:
IF @ReturnAsCSV = 1
BEGIN -
Anonymous
commented
This a sample as formatted by SQL prompt and doesn't make for easy reading:
IF isdate(@date) = 1 BEGIN
SELECT @dt = cast(@date AS Date)RETURN @dt
END