Activity overview
Latest activity by michaelb
Hey void
I guess it's just a matter of preference as sql server will probably convert your code internally into the sql 92 standard anyway when it compiles it into the database.
To me it makes more sense to use the version I posted previously, so an option to present it this way in the config screen would make people on both sides of the fence happy.
Michael / comments
Hey void
I guess it's just a matter of preference as sql server will probably convert your code internally into the sql 92 standard anyway when it compiles it into the database.
To me it makes more...
Hi Tilman,
Thanks for the prompt reply!
If you look at the example I put in my first post that should tell you the order I (and the team I program with) prefer to format our join statements as opposed to what I noticed in my trial so far.
In short the format would be:
select blah
from tbl1 as x
join tbl2 as y on y.col = x.col
I have to say that it gets better the more I play with it - great job! And the people I work with are impressed also. I'll definitely have a loo at v3 when it comes out!
Michael / comments
Hi Tilman,
Thanks for the prompt reply!
If you look at the example I put in my first post that should tell you the order I (and the team I program with) prefer to format our join statements as oppo...
join same table multiple times seems not to work properly
Hello all,
Just downloaded and installed SQL Prompt and am having a bit of a play to see what it can and can't do. First impressions are very good, but trying to join the same table twice in a quer...