新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
Powershell連接多服務(wù)器執(zhí)行SQL腳本
$query = " select @@servername" $csvFilePath = "c:\Scripts\queryresults.csv" $instanceNameList = get-content c:\Scripts\serverlist.txt $results=@() foreach($instanceName in $instanceNameList) { write-host "Executing query against server: " $instanceName $results += Invoke-Sqlcmd -Query $query -ServerInstance $instanceName } # Output to CSV write-host "Saving Query Results in CSV format..." $results | export-csv $csvFilePath -NoTypeInformation
網(wǎng)站欄目:Powershell連接多服務(wù)器執(zhí)行SQL腳本
文章位置:http://ef60e0e.cn/article/gsscjj.html