INERT statement

kkchan

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

Eddie D

Thank you for your post into the forum.

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