Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Auto Generate Script for Update

When Typing

UPDATE MyTable and then press TAB
it would be nice when SQL Prompt would generate
UPDATE MyTabLE SEt
MyField1 = @MyField1,
MyField2 = @MyField 2
etc

6 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Giuseppe shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  Thomas Walsh responded  · 

SQL Prompt has support for auto-completing INSERT statements which as of version 9.3, can be automatically refactored into an UPDATE statement, which should achieve a similar result to what has been requested.

Kind Regards,

The Prompt Team

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    Shame this still isn't fixed. It's preferable (though not ideal) to generate a script using the built-in SSMS script generation, which has all the columns as desired.

  • Steve commented  ·   ·  Report

    I know this is an old post, but I would love to see this as well. On a table with more than a few fields, creating this type of script is very tedious.