What are the challenges you face when working across database platforms? Take the survey
Options

how to format values clause on merge

mark_mmark_m Posts: 1 New member
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)
Tagged:

Answers

  • Options

    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


Sign In or Register to comment.