Comments
3 comments
-
Hi Andy,AndyScott wrote:The ability to specify the alias for a table would be really useful as the auto selected aliases do not match the aliases used throughout my companies code base which makes reading the SQL difficult as I am used to certain aliases meaning specific tables.
I think we're probably going to end up doing something about this for the final release as you're not the only person to have asked about it.The option to auto capitalise sql reserved words is gone in Version 3.
Yeah, but it's only a temporary absence. It'll be back for the final release.The following SQL brings up the wrong candidate list
select * from table1 AS t where t.Deleted='Y' and
I would of expected the candidate list to of contained the fields in table1 as happened when bringing up the candidate list after the where clause but the candidate list appeared with tables listed instead of fields.
Yep, that's a bug, although this had been working so I suspect I probably broke something at the last minute before the beta. Apologies for the hassle.
Thanks,
Bart -
Hi Bart, I forgot to say I am running SQL promp3.0 in Query Analyser.
Andy -
Thanks for that Andy. I think you'd find the same issues in SSMS in this case.
Cheers,
Bart
Add comment
Please sign in to leave a comment.
The option to auto capitalise sql reserved words is gone in Version 3.
The following SQL brings up the wrong candidate list
select * from table1 AS t where t.Deleted='Y' and
I would of expected the candidate list to of contained the fields in table1 as happened when bringing up the candidate list after the where clause but the candidate list appeared with tables listed instead of fields.