Powershell Stored Procedure with Parameters

Question

How would I add parameters to this stored procedure? And am I doing anything else wrong? I've already established my connection to server/db. I've searched, but keep getting conflicting answers. Any help would be appreciated!!

$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "sp_name_here"
$SqlCmd.Connection = $srcCnn

$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)

$DataSet.Tables[0]

Jake Bruun · Accepted Answer · 2016-02-17 23:33:00Z

2

You should be able to simply call the Add method on the command object's Parameters property.

$Param = $SqlCmd.Parameters.Add("@paramName", [Data.SqlDbType]::VarChar)
$Param.Direction = [Data.ParameterDirection]::Input
$Param.Value = "SomeValueHere"

answered Feb 17, 2016 at 23:33

Jake Bruun

1,32311 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Powershell Stored Procedure with Parameters

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related