Merge command formatting options
Please add formatting options for the deferent parts of the MERGE command like you have for INSERT
8
votes
Jermy
shared this idea
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