sample code
$strServer = 'localhost';
$strDatabase = 'MyTest';
$strUserId = 'xx';
$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()
}