Best way to use SSMS intellisense when querying
Posted on 2016-10-29
We want some tricks on using best way the the Microsoft SQL Server Management Studio Intellisense. We know that this tool helps one when querying but for some reason it's not working with us. We would like to:
- Type 'select' then being ask the table.
- If we type 'select table-name' and place the cursor after 'select' we would like to be
displayed a list of column for that table (without haing to place 'table-name C'.
- or if there some short we can store statements for faster scripting.
- Finally, any other good practice in time-saving query-typing any EE can help in.[/list]