SQLQueryWindowMultipleQueriesSampleFormsGUI

1.1

SQL Query Window UI with Multiple Pre-written Queries

   Features:
   * Able to return multiple results
   * Tests port 1433 before connecting to SQL to avoid longer connection timeout
   * Click on buttons to run pre-written queries
     - Option to show query from button either with or without executing
   * Able to re-query previous query on a timer
   * Ab
SQL Query Window UI with Multiple Pre-written Queries

   Features:
   * Able to return multiple results
   * Tests port 1433 before connecting to SQL to avoid longer connection timeout
   * Click on buttons to run pre-written queries
     - Option to show query from button either with or without executing
   * Able to re-query previous query on a timer
   * Able to limit rows returned (Top rows). Avoid too many rows returned!
   * Filter options when executing queries
   * -File parameter allows a list of SQL Servers (and databases) which shows in a dropdown
   * Login to SQL either with Windows Authentication or SQL User
   * Get button to get list of databases of current SQL Server and shows in database dropdown
   * Execute queries from query window
   * Has Settings Tab for additional options
   * Has SAMPLE buttons which can be modified in the script with additional queries


Installation Options

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

Install-Script -Name SQLQueryWindowMultipleQueriesSampleFormsGUI

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

Author(s)

John Merager

Copyright

12/21/2020

Owners

Tags

SQL TSQL T-SQL Server MS Microsoft Query Queries Multiple Report Reporting Loop Grid UI GUI Forms

Functions

ClickChangeTab StatusAddToBar StatusUpdate ShowMouseHoverToolTip UTCtoLocalTime UTCtoLocalTimeMinutes CurrentUTC OpenTextBox OpenTextBoxSizeChanged ClickSQLSourceList ChangedSelectSQLSource PingPort ExecuteSQLCommandFromButton SQLServersList_DClick SQLResult_DClick ExecuteSQLCommand ExecuteSQLCommandSimple ButtonShowDropdownList ClickAlwaysOnTop FormSizeChanged

Dependencies

This script has no dependencies.

Release Notes

1.0 This comes with multiple pre-written queries, including SAP related sample queries (Application specific).
Purpose: Sample SQL Query Window UI. It can be modified with queries specific to your needs.
Execute example:
powershell.exe -ExecutionPolicy Bypass -file .\SQLQueryWindowMultipleQueriesSampleFormsGUI.ps1
1.1 - Fixed grid size so scroll bars show properly

Version History

Version Downloads Last updated
1.1 (current version) 22 12/29/2020
1.0 7 12/25/2020