{"id":1169,"date":"2011-09-29T01:27:34","date_gmt":"2011-09-29T06:27:34","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1169"},"modified":"2011-10-14T21:07:03","modified_gmt":"2011-10-15T02:07:03","slug":"sql-formatter-option-align-value-of-parameter-in-execute-statement","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/09\/sql-formatter-option-align-value-of-parameter-in-execute-statement\/","title":{"rendered":"sql formatter option: align value of parameter in execute statement"},"content":{"rendered":"

This format option controls whether align value of parameter of SQL Server execute statement.<\/p>\n

name: exec_parameters_align_value, default is false<\/p>\n

setting path: Execute -> align value of parameter<\/p>\n

\nEXEC<\/span> Spr_store_note<\/span> @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_align_value to true, SQL will be formatted like this:<\/p>\n

\nEXEC<\/span> Spr_store_note<\/span> @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","protected":false},"excerpt":{"rendered":"

This format option controls whether align value of parameter of SQL Server execute statement. name: exec_parameters_align_value, default is false setting path: Execute -> align value of parameter EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_parameters_align_value to true, 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":"\nAlign value 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