How can we help you today?

How can we help you today?

Change syntax of Auto-generated Insert Statement

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?

Image: /hc/user_images/01JKDDSAEZB21BT3WSJWP6XZRT.png

rldawg August 26, 2020 14:46

0

Comments

2 comments

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 August 27, 2020 23:21

0
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

David_D August 28, 2020 16:25

0

Add comment

Please sign in to leave a comment.