Invoke-SqlCmd to -OutputAs Datatables -然后在写回SQL之前编辑数据表

# 执行SQL查询并将结果输出为DataTable对象
$result = Invoke-SqlCmd -ServerInstance "YourServer" -Database "YourDatabase" -Query "SELECT * FROM YourTable" -OutputAs DataTables

# 编辑数据表，这里以向数据表中添加一行数据为例
$newRow = $result.NewRow()
$newRow["Column1"] = "Value1"
$newRow["Column2"] = "Value2"
$result.Rows.Add($newRow)

# 写回SQL Server表
$connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True"
$bulkCopy = New-Object System.Data.SqlClient.SqlBulkCopy($connectionString)
$bulkCopy.DestinationTableName = "YourTable"
$bulkCopy.WriteToServer($result)

# 释放资源
$result.Dispose()
$bulkCopy.Close()
$bulkCopy.Dispose()