Sample SQL Commands for Database Management Professionals

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * Predefined SQL Connection
    * Custom SQL Connection
    * SQLite 3 Connection
    * SQL Query Tab
    * SQL Query Examples
    * SQL Script Tab
    * Script Replacements Tab
    * SSRS Deployments
    * SQL Operations
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

SQL Query Examples

The SQL Query result sets can be either generic (multiple rows, multiple columns), vertical (multiple rows, 1 column) or horizontal (1 row, multiple columns).

Generic example

Assuming the following binding properties set for the SQL query:

The data binding set should match the query result set so in this case, we’ll have the following result set:

Results

• any ListBox or ComboBox controls that have the associated property named COL_A_PROP will be populated withVAL_1A, VAL_2A,VAL_3A.
• any ListBox or ComboBox controls that have the associated property named COL_B_PROP will be populated withVAL_1B, VAL_2B,VAL_3B.
• any ListBox or ComboBox controls that have the associated property named COL_C_PROP will be populated withVAL_1C, VAL_2C,VAL_3C.
• properties COL_A_PROP,COL_B_PROP andCOL_C_PROP will be directly set toVAL_1A, VAL_1B and respectively VAL_1C (first result set row).

Before deploying the new result set, the previous binding content will be cleared.

Vertical example

Results

• any ListBox or ComboBox that have the associated property namedCOL_A_PROP will be populated withVAL_1A, VAL_2A,VAL_3A.

Horizontal example

Results

• properties COL_A_PROP,COL_B_PROP andCOL_C_PROP will be directly set toVAL_1A, VAL_1B and respectively VAL_1C (first result set row).

An empty result set is a valid output.

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: