{"id":1164,"date":"2011-09-28T22:23:38","date_gmt":"2011-09-29T03:23:38","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1164"},"modified":"2011-10-14T21:07:29","modified_gmt":"2011-10-15T02:07:29","slug":"sql-formatter-option-first-parameter-of-execute-statement-in-new-line","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/09\/sql-formatter-option-first-parameter-of-execute-statement-in-new-line\/","title":{"rendered":"sql formatter option: first parameter of execute statement in new line"},"content":{"rendered":"

This format option controls whether put a blank line before the first parameter of SQL Server execute statement.<\/p>\n

name: exec_first_paramater_in_newline, default is true<\/p>\n

setting path: Execute -> first parameter in newline<\/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

<\/p>\n

After set exec_first_paramater_in_newline to false, 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 put a blank line before the first parameter of SQL Server execute statement. name: exec_first_paramater_in_newline, default is true setting path: Execute -> first parameter in newline EXEC Spr_store_note @NoteId = 0, @TableTypeId = @TABLE_CUSTOMER, @RecordId = @CustomerId, @Descr = @Comments After set exec_first_paramater_in_newline to false, 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":"\nPut the first parameter of execute statement in a new line<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n