adolib

1.3

private/Get-OutputParameters.ps1

                                function Get-Outputparameters{

    param([Parameter(Mandatory=$true)][System.Data.SqlClient.SQLCommand]$cmd,

          [Parameter(Mandatory=$true)][hashtable]$outparams)

        foreach($p in $cmd.Parameters){

            if ($p.Direction -eq [System.Data.ParameterDirection]::Output){

              $outparams[$p.ParameterName.Replace("@","")]=$p.Value

            }

        }

    }