$sql = "select ..... for xml path('row')" # returns a long xml file $x = Invoke-sqlCmd -Server xxxx $sql $r = $x[0].ItemArray[0]
返回的$r有一个截断的xml字符串.如何确保返回完整的长字符串？@H_502_5@
请尝试以下方法：@H_502_5@
$x = Invoke-sqlCmd -Server xxxx $sql -MaxCharLength <some large enough number>
[1] http://blogs.technet.com/b/heyscriptingguy/archive/2013/05/06/10-tips-for-the-sql-server-powershell-scripter.aspx – 搜索-MaxCharLength@H_502_5@
