Geek asks and answers

Error inserting rows using $ (with Invoke-SqlCmd in Powershell

Setup:

CREATE TABLE MyTest (TestCol1 nchar(5))

Test:

Next job:

Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -OutputSqlErrors $True -Query "INSERT INTO MyTest VALUES ('`$5')"
Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -OutputSqlErrors $True -Query "INSERT INTO MyTest VALUES ('(5')"

Below is the error with the error below:

Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -OutputSqlErrors $True -Query "INSERT INTO MyTest VALUES ('`$(5')"
Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -OutputSqlErrors $True -Query "INSERT INTO MyTest VALUES ('`$`(5')"

Error: Invoke-Sqlcmd: By line: 1 char: 1 + Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -Ou ... + ~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ + CategoryInfo: ParserError: (:) [Invoke-Sqlcmd], ParserException + FullyQualifiedErrorId: ExecutionFailureException, Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

, $( powershell, , . , . . , ? CHAR SQL Server, , . .

+5
5

, $( Powershell, , CHAR $(CHAR (36)). , , Invoke-SqlCmd ADO.NET. , Invoke-SqlCmd , , .

0

, , invoke-Sqlcmd, -DisableVariables. $() sql.

Invoke-Sqlcmd -InputFile $fileName -ServerInstance $serverInstance -DisableVariables

http://msdn.microsoft.com/en-us/library/cc281720.aspx

+2

:

'INSERT INTO MyTest VALUES ("$(5")'

:

'INSERT INTO MyTest VALUES (''$(5'')'
0

$(anyvalue) - , SQLCMD.EXE $ sql CHAR (36):

Invoke-Sqlcmd -Database "databasename" -ServerInstance "hostname" -OutputSqlErrors $True -Query "INSERT INTO MyTest VALUES (CHAR (36) + '(5)')"

0
"INSERT INTO MyTest VALUES ('`$5')"


INSERT INTO MyTest VALUES ('$5')

"INSERT INTO MyTest VALUES ('(5')"


INSERT INTO MyTest VALUES ('(5')

"INSERT INTO MyTest VALUES ('`$(5')"


INSERT INTO MyTest VALUES ('$(5')

"INSERT INTO MyTest VALUES ('`$`(5')"


INSERT INTO MyTest VALUES ('$(5')

? "$ 5" $5? , $5. , , powershell? "There are $((Get-Process).Count) processes running" .

-2

More articles:


All Articles