title: add parameters to execute stored procedure in powershell
body: <p>I have problems when I try to execute a powershell script</p>
  
  <pre><code>$UuidMalo=0x0A398A6ADC9BE94CAD6769A81A7A5062
  $UuidBueno = 0xA66C97A21D6C2748BD7D7D865205293E
  
  $SQLCmd = New-Object System.Data.SqlClient.SqlCommand
  $SQLCmd.CommandType = [System.Data.CommandType]::StoredProcedure
  $SQLCmd.CommandText = $SQLCmdString
  $SQLCmd.Connection = $SQLConnection
  
  
  $SQLCmd.Parameters.Add("@contactUUID1",[system.data.SqlDbType]::Binary) 
  $SQLCmd.Parameters['@contactUUID1'].Direction = [system.data.ParameterDirection]::Input
  
  $SQLCmd.Parameters['@contactUUID1'].value = $UuidMalo1
  </code></pre>
  
  <p>the result after execute the script is</p>
  
  <pre><code>Must specify a file system
  Exception calling "ExecuteNonQuery" with "0" argument(s): "Failed to convert parameter value from a String to a Byte[].
  "
  At C:\Program Files\ca\PAM\scripts\mergeContacts.ps1:52 char:34
  + $Result = $SQLCmd.ExecuteNonQuery &lt;&lt;&lt;&lt; () | out-null
      + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
      + FullyQualifiedErrorId : DotNetMethodException
  </code></pre>
  
  <p>with convert method the system is not capable to convert it the input because is to big.</p>
  
  <p>this is the datatype in SQL</p>
  
  <p><img src="https://i.stack.imgur.com/4VspT.png" alt="enter image description here"></p>
  
  <p>how can I add the parameter without errors...?
  Thanks</p>