FreeKB - PowerShell SQL statements
PowerShell - SQL statements

The Invoke-Sqlcmd cmdlet can be used to execute SQL statements, such as select, insert, update, and delete. 


Sqlps Module

In order to use Invoke-Sqlcmd, you will first need to import the sqlps module. If PowerShell is being used on a PC that does not have SQL Server installed, the following software will need to be installed on the PC. If PowerShell is being used on the same PC as the SQL Server database, the following software should already be installed on the PC.

These files can be downloaded from

  • Microsoft System CLR Types for Microsoft SQL Server 2012 (SQLSysClrTypes.msi)
  • Microsoft SQL Server 2012 Shared Management Objects (SharedManagementObjects.msi)
  • Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2012 (PowerShellTools.msi)


Run this command.

Import-Module sqlps


If problems occur with this command, you can install SQL Server Management Studio on the PC.


Interacting with a SQL Server database

Following is an example PowerShell command to select data from SQL. You can use nearly any SQL statement in PowerShell.

Invoke-Sqlcmd -Query "select * from table_name" -ServerInstance "server_name or IP address" -Database "database_name" -Username "SQL_username" -Password "SQL_password"


Add a Comment

We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.

Please enter f2d70 in the box below so that we can be sure you are a human.


Web design by yours truely - me, myself, and I   |   |