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

SQL Prompt Breaks Nested REPLACE Functions Onto Multiple Lines

Some of the stored procedures I need to reformat have statements with nested calls to the REPLACE function. My current configuration causes these nested calls to be placed on new lines, as shown in this screenshot:



I'd like to see what settings are affecting this behavior. I'd prefer to have the entire statement on one line (or as few lines as possible) so that I can manually decide where to make the line breaks.
Tagged:

Best Answer

  • Options
    hassan_imamhassan_imam Posts: 37 Bronze 1
    Hey DataJedi, 

    Thank you for sending over the files. After testing your script, I observed that the default style behaves consistently. However, there's flexibility to enhance it by unchecking the options within the wrapping section or specifying a character limit for wrapping as needed.



Answers

Sign In or Register to comment.