6 ms·
I do it in UPDATES UPDATE FOO SET BAR = 1 , BAZ = 2 , QUUX = 3 I like it that way. Makes it clear the relationship between the continuing
by Pxtl 12y ago
I do it in UPDATES
UPDATE FOO
SET BAR = 1
, BAZ = 2
, QUUX = 3
I like it that way. Makes it clear the relationship between the continuing lines and their parents. Just the natural extension of
WHERE ALICE = 1
AND BOB =2
AND CHARLIE = 3
- dozenal 12y agoThat seems backwards to me. I put the operator on the previous line so I know the expression has more parts coming. In your example, I don't know SET BAR = 1 isn't the end until I read the next line.
- Pxtl 12y agoDifferent strokes I guess. I've tried both ways and I've found this one pleasant for scanning down an expression. I mean, it's kind of the SQL analogue to the MyObject .Child .Grandchild .ItsMethod(stuff) .HeyThatReturnedAnotherObject() .MoreObject(moreStuff)