Vscode-mssql: Support SQLCMD mode

[sidewinder94]

Would it be possible to implement a SQLCMD mode for executing SQL scripts ?

As of now, the syntax is not recognized by VSCode and the execution fails if using SQLCMD features.

[kzhui125]

please support syntax first, thanks

[estenrye]

Also would like to see the syntax updated to support SQLCMD

[OsirisDBA]

This isnt a full replacement for ssms until sqlcmd mode is supported unfortunately. But great work so far.

[tlagrone]

1up

[Carthorn]

1up :)

[lwohlhart]

1up

[choo75]

1up :)

[datamc-pdetomasi]

1up

[verschaevesiebe]

1up

[raviktech11]

1up

[abist]

The new version now supports SQLCMD!

[puruzio]

Which version supports this? I'm using 1.40.10, October 2019 build but it still says ":setvar" is incorrect syntax.

[sidewinder94]

@puruzio There is an "SQLCMD: Off" button that was added in the latest version, if you click on it it will enable the SQLCMD syntax & ability to run. Otherwise, it won't recognize the SQLCMD syntax.

[puruzio]

Sorry, where can I find that button? I looked all over but couldn't find it.

[abist]

@puruzio You can either access it via the command palette (Ctrl/Cmd + Shift + P) then look for SQLCMD or it's in the lower most bar when a query editor is opened.

[puruzio]

Sorry. Nothing under Ctrl/Cmd+SHift+P shows SQLCMD in its description. I checked in on both Mac OS and Windows versions of VS Code v1.40.0. What am I missing?

[abist]

@puruzio What version of the extension are you using? We introduced SQLCMD in version 1.7.0

[puruzio]

1.7.0 :(

[puruzio]

Never mind. I found it in the lower right corner of the task bar. Thanks!

[puruzio]

Just one more question. VS code still highlights ":setvar" as a syntax error even with SQLCMD:On. Is there a solution for that?

It seems to execute and format the code just fine. But the error message is annoying.