Change syntax of Auto-generated Insert Statement

rldawg

Is there a way in SQL Prompt to change the syntax of the auto-generated INSERT statement to use a SELECT instead of a Values clause?

David_D

Hello,

Based on the SQL Prompt options menu, the only option for INSERT statement is the VALUES clause. 



I can escalate this to my team and provide you with an update.

Thank you,
David Dang
Product Support Engineer

David_D

Hello @rldawg,

Unfortunately, there are currently no options or methods, and this would fall under a feature request. 

You can submit the feature request at Uservoice:

https://redgate.uservoice.com/forums/94413-sql-prompt

There is a similar existing feature request that you can vote on by commenting on having the option for using a SELECT instead of VALUES.

https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/38147416-multiple-format-options-for-insert-statements

As always, thanks for reaching out and using our products. Please let us know if you have any other questions or need additional help.

Kind regards,

David Dang

Product Support Engineer