How can we help you today? How can we help you today?

how to format values clause on merge

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)
mark_m
0

Comments

1 comment

Sort by
  • 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


    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.