Does anyone know if there's an add-in that does autocomplete for queries on SQL Management Studio?
From the SQL Prompt menu, click Options. Go to the Suggestions > Types of suggestion page. Select List all database columns after a SELECT statement.
On the Tools menu, click Options. Expand Text Editor, expand Transact-SQL, and then click IntelliSense.
Select the Edit menu, select IntelliSense, then select Refresh Local Cache. Use the CTRL+Shift+R keyboard shortcut.
Open SSMS – Click on Tools, Options, Expand Text Editor, Transact – SQL, and then uncheck the box next to Intellisense. That's it. We are done.
You can also try Devart's free SQL Complete.
http://www.devart.com/dbforge/sql/sqlcomplete/
Take a look at Red Gate's SQL Prompt.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With