{"id":1173,"date":"2011-09-29T01:35:32","date_gmt":"2011-09-29T06:35:32","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1173"},"modified":"2011-10-14T21:06:43","modified_gmt":"2011-10-15T02:06:43","slug":"sql-formatter-option-list-style-of-parameter-in-execute-statement","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/09\/sql-formatter-option-list-style-of-parameter-in-execute-statement\/","title":{"rendered":"sql formatter option: list style of parameter in execute statement"},"content":{"rendered":"

This format option controls whether list style of parameters in SQL Server execute statement, it can be stacked or wrapped.<\/p>\n

name: exec_parameters_style, default is stacked<\/p>\n

setting path: Execute -> parameter style<\/p>\n

\nEXEC<\/span> Spr_store_note<\/span>
\n
@NoteId<\/span> =<\/span> 0<\/span>,<\/span>
\n
@TableTypeId<\/span> =<\/span> @TABLE_CUSTOMER<\/span>,<\/span>
\n
@RecordId<\/span> =<\/span> @CustomerId<\/span>,<\/span>
\n
@Descr<\/span> =<\/span> @Comments<\/span>
\n<\/span><\/div>\n

After set exec_parameters_style to wrapped, SQL will be formatted like this:<\/p>\n

\nEXEC<\/span> Spr_store_note<\/span>
\n
@NoteId<\/span> =<\/span> 0<\/span>,<\/span>@TableTypeId<\/span> =<\/span> @TABLE_CUSTOMER<\/span>,<\/span>@RecordId<\/span> =<\/span> @CustomerId<\/span>,<\/span>@Descr<\/span> =<\/span> @Comments<\/span>
\n<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

This format option controls whether list style of parameters in SQL Server execute statement, it can be stacked or wrapped. name: exec_parameters_style, default is stacked setting path: Execute -> parameter style EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_parameters_style to wrapped, SQL will be formatted like this: EXEC Spr_store_note @NoteId = 0,@TableTypeId = @TABLE_CUSTOMER,@RecordId = @CustomerId,@Descr = @Comments <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,24,22],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nlist style of parameter in execute statement<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n