|
You can use many advanced properties of the Query
Analyzer to automate your task :
To insert values into a table without having to type all the
columns, open Query Analyzer
- Click on the main menu Automate and then click Introduce Insert
Statement
- Select the table you want to Insert from the Auto-completion
available
- Click inside the () and Select Introduce columns from the
Automate menu and all the columns will be entered
automatically
To Select values into a table without having to type all the
columns, open Query Analyzer
- Click on the main menu Automate and then click Introduce Select
Statement
- Select the table you want from the Auto-completion
available
- Click inside the () and Select Introduce columns from the
Automate menu and all the columns will be entered
automatically
You can perform Updates and Deletes in a similar fashion.
A block of statements can be Commented in one shot by selecting
them and using CTRL + ALT + Slash. Use CTRL + Slash to Comment a
single line of code. To Uncomment the statements use CTRL + Back
Slash.
The SQL Statements can be converted to Lower or Upper case using
the properties Morph to Upper, Morph to Lower options. An advanced
Morph to Delimited List is also available with the Query
Analyzer.
You can Format Current Statement as well as Scripts
|
