Posts
Sort by recent activity
Giving up on SQL Prompt 3 for now
Folks,
I really like the basic premise and idea behind SQL Prompt 3 - to provide database pros with intellisync in Query Analyzer and SQL Server Management Studio.
But I must say, the current versi...
"Count" not recognized as a reserved word
Folks,
I was trying to type a query something like
select count(*) from .....
but when I had typed "count" and wanted to go on, SQL Prompt jumped in and replaced that with "Country", which happens ...
Table aliases
Hmm..... SQL Prompt is trying to be helpful by adding table aliases - but again, it's not very smart discovering that one alias might already be in use....
I started with this query:
select * from ...
Not very smart on typed prefixes in general....
I just noticed SQL Prompt 3 doesn't seem to be very smart about pre-typed prefixes, either....
So I have a query like
select * from dbo.T_Contract as c
and then I go back to specify a few fields fr...
Doesn't detect a "dbo." prefix
Folks,
I like SQL Prompt 3 very much - looks just so much nicer and slicker than before!
However, one thing is bugging me: I often type
select <fields> from dbo.
and then hit Ctrl-Space. Now I can ...