62 results found
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 vote
SQL Prompt now supports suggestions from other databases when using the three part convention.
The Prompt Team
If you go
SELECT * FROM sys.tables AS t
SELECT * FROM sys.tables AS [t]
then intellisense will happily carry on working correcly, with t. now showing object members.
SELECT * FROM sys.tables AS "t"
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 vote
SQL Prompt 6.3 resolves quoted identifiers correctly
- Don't see your idea?