How can we help you today?

How can we help you today?

Formatting of an UPDATE Statement

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'

Lauren July 13, 2023 07:12

0

Comments

1 comment

Hi @...

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

Kurt_M July 18, 2023 07:55

0

Add comment

Please sign in to leave a comment.