如何在Powershell中执行存储过程？

Install-Module -Name SqlServer

Import-Module -Name SqlServer

$serverInstance = "服务器实例名称"
$database = "数据库名称"
$connectionString = "Server=$serverInstance;Database=$database;Integrated Security=True;"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$procedureName = "存储过程名称"
$parameters = @(
    New-Object System.Data.SqlClient.SqlParameter("@参数1", [System.Data.SqlDbType]::Int) -Value 123,
    New-Object System.Data.SqlClient.SqlParameter("@参数2", [System.Data.SqlDbType]::VarChar, 50) -Value "abc"
)

$command = New-Object System.Data.SqlClient.SqlCommand($procedureName, $connection)
$command.CommandType = [System.Data.CommandType]::StoredProcedure
$command.Parameters.AddRange($parameters)

$result = $command.ExecuteNonQuery()

$result = $command.ExecuteReader()

$connection.Close()