IntelliSense issue?
DB I'm using: SQL Server
A pic is worth a 1000 words so here goes:
`p` is a table alias. Why does list SQL Server `functions` and `global variables` on a table alias (& probably other things). The result is there is a ton of things in my IntelliSense & finding anything especially when your unfamiliar with new table is a PAIN. It also does the same thing if you type p.<columnName>. it will list all global variables & functions.
Now if i type @ or @@ it would expect it to list the global variables or if i start typing `Date` then maybe i would see the DateAdd function.
Here is an example of what SSMS (Sql Server Management Studio) does:
It has some extra stuff at the bottom but at least it list the table columns up top.
When i type i `@`
The IntelliSense is kind of a mess (no offense). Maybe there is a way to configure it better but i've tried to go through everything & can't seem to find anything.
请先登录再写评论。
Hi ncage,
Do you have the Sort suggestions alphabetically option checked in File | Settings | Editor | General | Code Completion? If yes, uncheck it, apply the changes, and let me know if that resolves the issue.
If the option is unchecked and the issue persists, kindly provide the following:
Thanks Anastasia Kazakova . That was it. Now it's working how I expect it to. It must have been the default because I never changed it. You might want to make sure its “unchecked” by default. It got to the point where i wasn't using it anymore. Sometimes finding the option/setting can be hard :).
ncage,
The 'Sort suggestions alphabetically' option is actually unchecked by default. However, there used to be an option to change the order in the completion popup, so maybe it was accidentally selected. Anyway, glad to hear that unchecking it helped!