Competition: What’s your favorite Redgate tool? Enter now.

Is it possible to format SQL script in SQLCMD mode?

ogrishmanogrishman Posts: 78 Bronze 4
edited February 10, 2015 9:13AM in SQL Prompt
Currently I got errors when trying to format scripts in SQLCMD mode. It told me I have syntax errors in my code and has been highlighted.

Thanks.

Comments

  • Hi Ogrishman,

    SQLCMD mode is not currently supported in Prompt, we have a UserVoice request for it here so please do add your vote. Hopefully we'll get this implemented in v7 but we have lots of other possible feature requests that we have to prioritise it against.

    Thanks,
    Aaron.
  • Hi Ogrishman,

    I just wanted to give you an update on this: We've added support for SQLCMD mode in our 6.5 beta, which you can download from here. This should allow you to format scripts containing SQLCMD and it'll also help with suggestions when editing it. Please let us know if this works for you.

    Thanks,
    Aaron.
Sign In or Register to comment.