Formatting of an UPDATE Statement
00leel00
Posts: 1 New member
in SQL Prompt
Is there a way to get the fields of an UPDATE statement to line up like they do with a SELECT statement?
e.g.
Current
UPDATE xxx
SET Field_1 = 'Something'
,Short = 'Something'
,LongName = 'Something'
Desired
UPDATE xxx
SET Field_1 = 'Something'
,Short = 'Something'
,LongName = 'Something'
e.g.
Current
UPDATE xxx
SET Field_1 = 'Something'
,Short = 'Something'
,LongName = 'Something'
Desired
UPDATE xxx
SET Field_1 = 'Something'
,Short = 'Something'
,LongName = 'Something'
Tagged:
Answers
Unfortunately, you can only line up the column names and not the 'Something' values. This might be something worth suggesting over on our Uservoice forum: https://redgate.uservoice.com/forums/94413-sql-prompt
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center