如何使用invoke-sqlcmd从Powershell正确格式化XML输出

Install-Module -Name SqlServer

Import-Module -Name SqlServer

$connectionString = "Server=<服务器名称>;Database=<数据库名称>;User ID=<用户名>;Password=<密码>"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$query = "SELECT * FROM <表名> FOR XML AUTO, ELEMENTS"

$command = New-Object System.Data.SqlClient.SqlCommand($query, $connection)
$xmlResult = $command.ExecuteXmlReader()

$xmlDoc = New-Object System.Xml.XmlDocument

$xmlDoc.Load($xmlResult)

$connection.Close()

$xmlString = $xmlDoc.OuterXml
$formattedXml = [System.Xml.Linq.XDocument]::Parse($xmlString).ToString()