executing-sql-statements-using-powershell2

executing-sql-statements-using-powershell2_1.ps1

Import-Module SQLPS -DisableNameChecking

#replace your with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

#replace your with your user database name
$dbName = "name_user_db"
$db = $srv.Databases[$dbName]

executing-sql-statements-using-powershell2_2.ps1

#Similar to a ado.net execute non query
Invoke-Sqlcmd `
-ServerInstance "$instanceName" `
-Database $dbName `
-Query "INSERT INTO [dbo].[test1] ([column1]) VALUES (1)"  

executing-sql-statements-using-powershell2_3.ps1

#execute query and export to a CSV
Invoke-Sqlcmd `
-ServerInstance "$instanceName" `
-Database $dbName `
-Query "SELECT TOP 1000 [column1],[id] FROM [dbo].[test1]" |
Export-Csv -LiteralPath "C:\results.csv" `
-NoTypeInformation