Get-StoredProcedureOutputParameter.ps1

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection 
$SqlConnection.ConnectionString = "integrated security=SSPI;` data source=$ServerName;` initial catalog=$DatabaseName;" 
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand 
$SqlCmd.CommandText = "sp_sw_rtree_is_created" 
$SqlCmd.Connection = $SqlConnection 
$SqlCmd.CommandType = [System.Data.CommandType]'StoredProcedure'; 
$SqlCmd.Parameters.AddWithValue("@owner", "$OwnerName") >> $null; 
$SqlCmd.Parameters.AddWithValue("@table", "$TableName") >> $null; 
$SqlCmd.Parameters.AddWithValue("@spatialcolumn", "$SpatialColumn") >> $null; 
$SqlCmd.Parameters.AddWithValue("@keycolumn", "$KeyColumn") >> $null; 
$outParameter = new-object System.Data.SqlClient.SqlParameter; $outParameter.ParameterName = "@truth"; 
$outParameter.Direction = [System.Data.ParameterDirection]'Output'; 
$outParameter.DbType = [System.Data.DbType]'Boolean'; $SqlCmd.Parameters.Add($outParameter) >> $null; 
$SqlConnection.Open(); 
$result = $SqlCmd.ExecuteNonQuery(); 
$truth = $SqlCmd.Parameters["@truth"].Value; 
$SqlConnection.Close(); 
$truth;