Powershell访问SQL Server数据库代码实例
支持所有版本的SQLserver。
你是否需要连接数据库?这里有一段代码演示如何查询和获取SQL数据,只需非常简单正确的配置你的账户信息、服务器地址及SQL语句就行:
$Database ='Name_Of_SQLDatabase' $Server ='192.168.100.200' $UserName ='DatabaseUserName' $Password ='SecretPassword' $SqlQuery ='Select*FROMTestTable' #AccessingDataBase $SqlConnection =New-Object-TypeNameSystem.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString="DataSource=$Server;InitialCatalog=$Database;userid=$UserName;pwd=$Password" $SqlCmd =New-ObjectSystem.Data.SqlClient.SqlCommand $SqlCmd.CommandText =$SqlQuery $SqlCmd.Connection =$SqlConnection $SqlAdapter =New-ObjectSystem.Data.SqlClient.SqlDataAdapter $SqlAdapter.SelectCommand =$SqlCmd $set =New-Objectdata.dataset #FillingDataset $SqlAdapter.Fill($set) #ConsumingData $Path="$env:temp\report.hta" $set.Tables[0]|ConvertTo-Html|Out-File-FilePath$Path Invoke-Item-Path$Path