Merge command formatting options
Please add formatting options for the deferent parts of the MERGE command like you have for INSERT
![](https://secure.gravatar.com/avatar/ebd4976473c275af72e6f4800ca3b71b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Patrick commented
Keeping the value lists on a single line would be a useful option.
MERGE INTO [table] AS Target
USING (
VALUES (
('USER', 'UPDATE', 'blabla.', 1, 2, 3, 4, GETDATE(), 'Admin', GETDATE(), 'Admin' )
, ( 'USER', 'INSERT', 'more blabla.', 1, 2, 3, 4, GETDATE(), 'Admin', GETDATE(), 'Admin' )
) AS Source