INERT statement

kkchankkchan Posts: 33
edited December 27, 2007 11:31AM in SQL Prompt Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.