What are the challenges you face when working across database platforms? Take the survey
Options

Column Picker on INSERT Statement

davegrdavegr Posts: 15
edited March 14, 2011 1:17PM in SQL Prompt Previous Versions
If I key in

INSERT INTO MyTable(

I get the colum the list of columns as suggestions but the Column Picker is not available. Selecting the columns individually is fine when there are only a few columns but not when the table has over 100 columns. Is there something I need to do to get the Column Picker working for this statement?

The Column Picker works fine with a regular SELECT statement.

Thanks

Dave

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    Column picker is designed to work only with select statement hence it does not work with 'Insert into' statements.

    We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3854.

    It will be reviewed by product manager and than marked for the future release.

    I will update you as soon as it is incorporated.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Thanks Anu,

    For now I just key in a SELECT statement to get the Column Picker and then after choosing the columns, change the code to an INSERT INTO statement. This at least saves the typing or selection of all the column names one by one.

    I look forward to seeing this functionality added to a future release.

    Regards

    Dave
Sign In or Register to comment.