Best way to use SSMS intellisense when querying
HI,
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]
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]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Appreciate a feedback on this.
Regards,
Pawan
Appreciate a feedback on this.
Regards,
Pawan
You may have to change the selected database just in case your SSMS is using something like master as the default.