Advanced SQL Querying
The articles in this section demonstrate some more advanced techniques that can be used to query your database.
Advanced
-
Creating Dynamic SQL statements that reflect user form selections at SQLBook.com
A frequent business requirement is the implementation of a form that allows a user to filter data. This can require the developer to create dynamic SQL statements that reflect the filters specified by the user
-
Creating a comma delimited list of column values without a SQL cursor at SQLBook.com
There may be many reasons you want to build a comma delimited list of values from a table column. This article demonstrates how to build this list without using a cursor.
-
Using SQL Cross Join - the report writers secret weapon
The SQL CROSS JOIN is an often overlooked part of SQL but it can prove invaluable if you are aware of which situations it can be useful in.
-
SQL Cursors - how to avoid them
Whilst many SQL books advise you not to use SQL cursors, not many provide alternative solutions. This article shows how alternatives to cursors can be implemented.
-
Using SQL to parse a comma delimited list - example code
This example SQL script shows how to parse a comma delimited list using SQL