How can we help you today? How can we help you today?

No hints on insert

Previously, when entering the "insert into TABLE" command, the program would prompt for a list of fields. This has now been stopped in SQL Manager 2022.

Piotr Żychski
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Good Morning Piotr Żychski ,

    Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your Prompt installation in SSMS 2022. In this case I would like to confirm we did not deselect any Prompt settings when uprading to SSMS 2022 could you check if you have:

    • SQL Prompt ▸ Options ▸ Inserted code ▸ Objects & statements
    • Under INSERT statements, enable the option to insert column names (and any desired defaults/data types).

    As well as the more basic suggestion option:

    SQL Prompt ▸ Options ▸ Behavior ▸ Enable code suggestions is checked.

    Lets try the above and see if that fixes your behavior.

    Best,

    Christian Perez
    Product Support Engineer

    Christian Perez

Add comment

Please sign in to leave a comment.