How can we help you today? How can we help you today?

Hints to help intellisense work more effectively?

The principle of SQL Prompt is great, but if you're creating a stored procedure that only references a single table, having the intellisense prompt for just about all of the objects in the SQL Server is a bit long-winded.

The USE keyword indicates which database you're after, so if SQL Prompt was sensitive to that, all other databases could be removed from the list which would be a start.

A further sophistication would be for situations which demand two or more tables. If 'hints' could be placed in comments (perhaps on the first line) eg 
-- USE Northwind.Categories, Northwind.OrderDetails
which would then restrict the intellisense to just two tables it would make it a whole lot more useful. It may be that some other key code (ALT SpaceBar?) would make intellisense revert to 'normal' operation.

Crispin
CrispinH
0

Comments

2 comments

Sort by
  • Lionel
    Not sure if people would really be bothered to use those hints in comments. Wouldn't it be better if we added a feature that scanned all the objects you used your stored procedure and moved thouse to the top of the list in a most recently used section?

    Lionel
    Lionel
    0
  • CrispinH
    Lionel

    I think that's a goo idea, but your idea and hints aren't mutually exclusive - they could co-exist.

    Crispin
    CrispinH
    0

Add comment

Please sign in to leave a comment.