Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server 2008 autocomplete for "TOP" keyword

Either the autocomplete in SQL Server Management Studio 2008 is buggy, or I am. Either way, when I try to type this and hit the spacebar:

SELECT TOP 

Autocomplete immediately changes it to this (Topics is a table in one of our databases, btw):

SELECT Topics

Is there a way to fix, or at least gracefully work around this?

like image 487
Mass Dot Net Avatar asked Dec 18 '22 05:12

Mass Dot Net


2 Answers

Unfortunately, no. SSMS Intellisense is a 1.0 product, and is not as feature-rich as many third-party products. You can turn it off OR ignore the suggestion (with the ESC key).

like image 145
Stuart Ainsworth Avatar answered Jan 19 '23 01:01

Stuart Ainsworth


I think all you can do is hit ESC when the intellisense pop-up appears which will cancel any change it makes, or just turn Intellisense off completely by going to Text Editor -> Transact-SQL -> Intellisense.

like image 26
tbreffni Avatar answered Jan 19 '23 02:01

tbreffni