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

comments confuse reformat

rbennet8rbennet8 Posts: 74
edited October 26, 2012 2:32PM in SQL Prompt Previous Versions
consider this snippet.
@back_up_path varchar(500), -- path for backup directory
@log_path varchar(500), -- path for log directory
@JobID BINARY(16),
If you choose comma first, reformat changes it to
,@back_up_path VARCHAR(500)
, -- path for backup directory
@log_path VARCHAR(500)
, -- path for log directory
@JobID BINARY(16)
it should be reformatted as this
,@back_up_path varchar(500) -- path for backup directory
,@log_path varchar(500) -- path for log directory
,@JobID BINARY(16)

Comments

Sign In or Register to comment.