Powershell 访问Sql数据库

一段简单的访问数据库查询数据的代码：

$sqlServer = "192.168.0.1/SQLExpress"
    $database = "DBDemo"
    $saPassword = ******"
    $sqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $cnnString = "Server=$sqlServer;Database=$database;User ID=sa;Password=$saPassword;Trusted_Connection=False"

    $sqlConnection.ConnectionString = $cnnString
    $sqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $sqlCmd.Connection = $sqlConnection
    $sqlCmd.Connection.Open()
    $sqlCmd.CommandText = "SELECT * FROM [DBDemo].[DBO].[TableName]"

    $adapter = New-Object System.Data.SqlClient.SqlDataAdapter $sqlCmd
    $dataset = New-Object System.Data.DataSet

    $adapter.Fill($dataSet)

    $sqlConnection.Close()

 

for ($i=0; $i -lt $dataSet.Tables[0].Rows.Count; $i++)
{

      $data= $dataSet.Tables[0].Rows[$i][0]

}

 

 

插入数据

   # $sqlCmd = New-Object System.Data.SqlClient.SqlCommand
   # $sqlCmd.CommandText = "INSERT INTO [DBDemo].[DBO].[TableName] ([Kye1], [Kye2], [Kye3], [key4]) VALUES ('$value1', '$value2, '$value3, '$value4)"
    $sqlCmd.Connection = $sqlConnection
    $sqlCmd.ExecuteNonQuery()