CODEWITHSUNDEEP
scriptingpowershell-2.0sqlcmd
David S.
David S.

Reputation: 11200

how to include a ":" as a parameter in powershell?

i have a simple powershell script, like this

sqlcmd -S. -E -Q 'select ''$(x)''' -v x="c:a"

but i always got the error message

Sqlcmd: ':a': Invalid argument. Enter '-?' for help.

i figured out that it is the ":" in the argument caused the problem, but i do not know how to escape it.

thanks, David

Upvotes: 1

Views: 1970

Answers (3)

Sharath Satish
Sharath Satish

Reputation: 104

You could also alternatively try this approach that we used for scripting xdt:Transforms.

$xmlSection.SetAttribute("xdtTransform","Insert")

followed by

foreach-object {$_ -replace "xdtTransform" , "xdt:Transform"}

Upvotes: 0

David S.
David S.

Reputation: 11200

sorry that i have to answer to my own question again.

the only way to solve this problem is to use '+' to concatenate the two string, and the ':' will be reserved.

e.g. $a="abc"+":123"

Upvotes: 3

Warren Rumak
Warren Rumak

Reputation: 3874

The backquote character is the escape code in PowerShell. So write ``:` ....

oops... That won't work for the colon character. Use %3A instead.

Upvotes: -1

Related Questions