how to format values clause on merge

mark_m

VALUES

(1, 0, N'Base Type', N'Base Type', 0, 1, '2019-05-29T18:53:19.4700000', '2019-05-29T18:53:19.4700000', 1, 1, 1),

(2,

0 ,

N'EntityMasterRecord',

N'Entity Master Record',

1,

1,

'2019-05-30T13:30:08.4633333',

'2019-05-30T13:30:08.4633333',

1,

1,

1

)

Would like to format each values on single line

(1, 0, N'Base Type', N'Base Type', 0, 1, '2019-05-29T18:53:19.4700000', '2019-05-29T18:53:19.4700000', 1, 1, 1),

(2,0 ,N'EntityMasterRecord',N'Entity Master Record',1,1,'2019-05-30T13:30:08.4633333','2019-05-30T13:30:08.4633333',1,1,1)

Pete_Ruiz

Hi Mark,

You can do this by setting the option to Place subsequent values on new lines to Never in SQL Prompt>Edit formatting styles>Expressions>IN and under Values.

​

​

I hope this helps. Please let me know if there are any further questions.

Kind regards,

Pete Ruiz

Redgate Support