Illustrative SQL Queries: A Comprehensive Guide

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:

COL_A	COL_B	COL_C
ROW_1	VAL_1A	VAL_1B	VAL_1C
ROW_2	VAL_2A	VAL_2B	VAL_2C
ROW_3	VAL_3A	VAL_3B	VAL_3C

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.