Invoke-SqlQuery

1.0.0

This command uses the .NET SqlClient classes to connect to a SQL database and execute any type of query. The default behavior is to use integrated Windows authentication, but you can pass a credential object for a username and password. This works well when run on Linux.

When you run a SELECT query the command will write a custom object for each row to the pipeline.
This command uses the .NET SqlClient classes to connect to a SQL database and execute any type of query. The default behavior is to use integrated Windows authentication, but you can pass a credential object for a username and password. This works well when run on Linux.

When you run a SELECT query the command will write a custom object for each row to the pipeline.
Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name Invoke-SqlQuery

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2017 JDH Information Technology Solutions, Inc.

Package Details

Author(s)

  • Jeff Hicks

Tags

SQL

Dependencies

This script has no dependencies.

Release Notes

This script is still being developed for cross-platform support in Linux.

FileList

Version History

Version Downloads Last updated
1.0.0 (current version) 615 7/21/2017