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
![](https://secure.gravatar.com/avatar/fe05a4f7c40f4866859591c3270f1c58?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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