Can notepad++ support sqlcmd syntax somehow?

Question

I like using notepad++ for my syntax editing because it can handle all the languages I work in.

However, when I load a TSQL script that uses SQLCMD stuff, it messes up the highlighting.

For example, if you have a sql file with this in it :setvar DefaultDataPath "D:\Data\" then everything after that will be light grey.

Is there a way to tell notepad++ to not do that?

David Starkey · Accepted Answer · 2013-02-28 21:16:37Z

1

It seems the issue here is coming from the \" at the end of your line. Notepad++ appears to be translating that as an escaped quote (") so it believes to still be in the same string.

I have not seen anything in Notepad++ that would automatically fix this for you (but to be honest I did not look too much into it). Some alternative options:

"D:\Data"
"D:\Data\""
"D:\Data\\"

I notice Notepad++ having these types of problems quite often but they are purely cosmetic issues.

answered Feb 28, 2013 at 21:16

David Starkey

1,8503 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can notepad++ support sqlcmd syntax somehow?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related