Comments
Sort by recent activity
Huh? That's weird. I was certain that I got an error when I tried this the last time, but now it does run just fine.
The syntax diagram at https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx does seem to suggest that brackets are mandatory, and all the examples (for PIVOT, not for UNPIVOT) have them (but then, they all use numerical values, not strings, which SQLPrompt does indeed leave intact).
I looked a bit further, and the syntax diagrams at https://technet.microsoft.com/en-us/library/ms177634(v=sql.105).aspx show that the IN list is supposed to contain column names, and in that case I have to agree that "Black" and "[Black]" are both correct; this is not a bug after all.
Sorry for wasting your time!
Cheers,
Hugo / comments
Huh? That's weird. I was certain that I got an error when I tried this the last time, but now it does run just fine.
The syntax diagram at https://technet.microsoft.com/en-us/library/ms177410(v=sql...
I'm attending and speaking. A bit of a niche subject: instead of my usual performance talks, I will showcase some interesting Service Broker solutions I have worked over the years. Should be good! / comments
I'm attending and speaking. A bit of a niche subject: instead of my usual performance talks, I will showcase some interesting Service Broker solutions I have worked over the years. Should be good!