Error when formatting in SQLCMD mode

JonBruneJonBrune Posts: 7 New member
SQL Prompt is changing this:
:SETVAR MyVar      "Foo"

-- SQL Prompt formatting off
INSERT INTO #MyTable
(
    Col1
)
VALUES
 ('1')
-- SQL Prompt formatting on
into:
:SETVAR MyVar      "Foo":SETVAR MyVar      "Foo"-- SQL Prompt formatting off
INSERT INTO #MyTable
(
    Col1
)
VALUES
 ('1')
-- SQL Prompt formatting on
I'd like to submit a bug for this but it looks like the options are ask a question or start a discussion.  Maybe bugs are to be submitted elsewhere?


Best Answer

  • Alex BAlex B Posts: 620 Rose Gold 4
    Accepted Answer
    Hi @JonBrune,

    I see this happening as well - it seems specifically related to "-- SQL Prompt formatting off" comment following the :Setvar.  I have raised this with the team as SP-7591 and will update you when I have further information from the team.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.