INERT statement
kkchan
Posts: 33
Hi,
SQL Prompt auto list out INSERT code template after I key in INSERT INTO mytable. Anyway to:
1. Allow me to select what fields to be inserted, or all?
2. Allow navigation to each value portion?
Thank you
SQL Prompt auto list out INSERT code template after I key in INSERT INTO mytable. Anyway to:
1. Allow me to select what fields to be inserted, or all?
2. Allow navigation to each value portion?
Thank you
Comments
You can control the INSERT or INSERT INTO code template using the following option:
SQL Prompt Menu->Options->Inserted Candidates Tab->Select SQL in the Left Hand Column List->Insert full INSERT Statement.
Unchecking the 'Insert full INSERT Statement' disables the code template completely.
The other 4 options, control what code template displays:
Insert default values for data types
Show hints for data types
Force statement onto a single line
Include column name hints
Unfortunately there is not an option to select what fields to be inserted.
I am unsure what you mean by 'Allow navigation to each value portion'. Unless you mean movement of the cursor using the Ctrl and the left or right arrows together.
Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com