How do I escape the "&" symbol in Sql server

Question

I have to execute the following code in query editor

Exec xp_cmdshell 'sqlps -command "$http=New-Object system.Net.WebClient;$http.uploadString(\"http://192.168.2.3:8080/ThermalMap/DBTest.jsp\",\"param1=somevalue & param2=thriu\")"'

It gives me error.

But the following code is working well and gives me output

Exec xp_cmdshell 'sqlps -command "$http=New-Object system.Net.WebClient;$http.uploadString(\"http://192.168.2.3:8080/ThermalMap/DBTest.jsp\",\"param1=somevalue\")"'

Here in second code am passing single parameter and I don't get any error If I pass two parameter I need to add "&" symbol and am getting error. How can I escape "&" symbol here?

Please refer to the following question: http://stackoverflow.com/questions/881194/how-to-escape-special-character-in-mysql — Jean-Paul, Aug 10 '13 at 08:46

score 3 · Accepted Answer · answered Aug 10 '13 at 09:15

3

According to this article you need to escape ampersands like this: ^&. Unescaped ampersands are treated as a command separators.

answered Aug 10 '13 at 09:15

Ansgar Wiechers

184,186
23
230
299

How do I escape the "&" symbol in Sql server

1 Answers1