SQL Test Queries

There are a lot of possible queries, and tricky to keep track of and support all possible variations.

In the project I run tests on a lot of different queries so that I can keep track on what is working and not, and also to make sure that future changes do not break the old functionalities.

Here follows a list of pages containing SQL queries and their generated XML. All the queries in these pages are tested with each build and a failed test will cause build failure.

Do not fear! More tests are on their way

• SQL Test Queries - AND / OR

• SQL Test Queries - ORDER BY

• SQL Test Queries - GROUP BY

• SQL Test Queries - NULL

• SQL Test Queries - LIMIT

• SQL Test Queries - JOIN

• SQL Test Queries - Field Selection

• SQL Test Queries - IN statement

• SQL Test Queries - LIKE statement

• SQL Test Queries - Gt statement

• SQL Test Queries - Geq statement

• SQL Test Queries - Lt statement

• SQL Test Queries - Leq statement

• SQL Test Queries - Neq statement

• SQL Test Queries - Leq statement

• SQL Test Queries - Boolean parameters

• SQL Test Queries - Numeric parameters

• SQL Test Queries - DateTime parameters

• SQL Test Queries - Text parameters

• SQL Test Queries - User parameters

• SQL Test Queries - Membership parameters

• SQL Test Queries - Combinations