62 results found
-
Please provide intellisense even when not in the current database
In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)
1 voteSQL Prompt now supports suggestions from other databases when using the three part convention.
Kind Regards,
The Prompt Team
-
Supprt Quoted identifiers for prompting
If you go
SELECT * FROM sys.tables AS t
or
SELECT * FROM sys.tables AS [t]then intellisense will happily carry on working correcly, with t. now showing object members.
However
SELECT * FROM sys.tables AS "t"
and
SELECT * FROM sys.tables AS 't'both cause the intellisense to give up for the rest of the batch. All four identifier markups are valid (for now) and should be treated equally...
1 voteSQL Prompt 6.3 resolves quoted identifiers correctly
- Don't see your idea?