Writing to SQL Server

    1. $colb = @('Stuff1','Stuff2','Stuff3')
    2. $connection_string = "Server=.\SQLExpress;AttachDbFilename=C:\Myfiles\mydb.mdf;Database=mydb;Trusted_Connection=Yes;"
    3. $connection = New-Object System.Data.SqlClient.SqlConnection
    4. $connection.Open()
    5. $command = New-Object System.Data.SqlClient.SqlCommand
    6. $command.Connection = $connection
    7. $command.CommandText = $sql
    8. $command.ExecuteNonQuery()
    9. }
    10. $connection.close()