Cacher is the code snippet organizer for pro developers

Write-Host "Connecting to database $dbName"

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection

$SqlConnection.ConnectionString = "Server=localhost;Database=$dbName;User ID=$username;Password=$sqlPassword;Connect Timeout=180"

$SqlConnection.Open();

Write-Host "Successfully connected to $dbName"

$query = Get-SQLQuery $scrp

$cmd = New-Object System.Data.SqlClient.SqlCommand($query,$SqlConnection)

Write-Host "Executing query $scrp"

$cmd.CommandTimeout= 120

$cmd.ExecuteNonQuery();