powershell - database(insert)

sample code

# 接続情報設定
$strServer   = 'localhost';  # サーバーを指定
$strDatabase = 'MyTest';     # データベースを指定
$strUserId   = 'xx';         # ユーザーIDを指定
$strPassword = 'xxxx';       # パスワードを指定

$cnnstr = "Data Source=$strServer;Initial Catalog=$strDatabase;User ID=$strUserId;Password=$strPassword;"

$cnn = New-Object -TypeName System.Data.SqlClient.SqlConnection $cnnstr

try {
    $cnn.Open()

    $tran            = $cnn.BeginTransaction()
    $cmd             = $cnn.CreateCommand()
    $cmd.Connection  = $cnn
    $cmd.Transaction = $tran
    $cmd.CommandText = "insert into members (name, sex) values(@name, @sex)"

    [void]$cmd.Parameters.AddWithValue("@name", "kato")
    [void]$cmd.Parameters.AddWithValue("@sex", 1)
    [void]$cmd.ExecuteNonQuery()

    $tran.Commit();
}
catch {
    Write-Output $Error[0].Exception.Message
    $tran.Rollback()
} finally {
    $cnn.Close()
    $cnn.Dispose()
}