Escape sequence for $ (dollar sign) in T-sql script

Question

I am running a T-SQL script called from a powershell script that contains a text string that includes a sequence containing $ (MV).

When I run the script, I get the error “the script variable MV is not defined.” Which I assume because it interprets the string $ (MV) as a variable instead of being part of a text string.

How can I write a dollar sign as an escape sequence? Is this possible in line?

Answer 1

You can use the backtick to avoid the $ sign in PowerShell:

`$ 

Answer 2

Is the script running with sqlcmd ? It will interpret $ (variablename) and try to expand it.

You can disable this using the -x command line option.

Oh, if you use Invoke-Sqlcmd , you can use the -DisableVariables parameter.

I assumed that you do not want the sqlcmd variable to be replaced. If you were just trying to get $ past Powershell, use the backlink (`$) as in the other sentence.