SQLQueryBuilder

1.0.0.1

A collection of PowerShell cmdlets to build SQL query strings, inteded for user with Invoke-SqlCmd (SQLServer).

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name SQLQueryBuilder

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

Install-PSResource -Name SQLQueryBuilder

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

Copyright (c) 2020 Bentley Systems, Incorporated. All rights reserved.

Package Details

Author(s)

  • Zachary F. Kerr

Functions

Format-SQLSelectRowByKeyQuery Format-SQLInsertRowQuery Format-SQLUpdateRowByKeyQuery Format-SQLCreateTableQuery Format-SQLSelectTableInformationQuery Remove-SpecialCharactersFromString

Dependencies

This module has no dependencies.

Release Notes

Added Remove-SpecialCharactersFromString, and updated other cmdlets to clean strings before defining column names.

FileList

Version History

Version Downloads Last updated
1.0.0.1 (current version) 334 6/22/2020
1.0.0.0 23 6/2/2020