title: Invoke-SqlCmd doesn't return long string?
body: <p>For the following code</p>
  
  <pre><code>$sql = "select ..... for xml path('row')" # returns a long xml file
  $x = Invoke-SqlCmd -Server xxxx $sql
  $r = $x[0].ItemArray[0]
  </code></pre>
  
  <p>The returned <code>$r</code> has a truncated xml string. How to make sure the full long string is returned?</p>