SQL Articles

With a database table comprising of two zip codes, it is easy to calculate a distance between these two points for basic location-aware searching.

SQL Cursors can be helpful, although over-use or misuse by developers is quite common. Understanding the proper methods to use and implement Cursors can improve chances for success.

Often times you might need to extract data from SQL into a comma-separated listing of values. This seemingly simple task is not quite as simple as you expect.

Sometimes you just don't know what you want to query until it comes time to execute the query, this post explores options for creating dynamic where clauses.

Dynamically attached databases seem incredibly helpful at first glance, however, with anything easy there is always a gotcha, and dynamically attached databases are no different.

Rank, ROW_NUMBER, and Partition are incredibly powerful SQL statements but often misunderstood. This post outlines example usages to illustrate their effectiveness.

To fully test your database-driven applications you need test data, it can be tedious to populate, so let us explore a few quick ways to add data.

The IN clause is a helpful SQL query item, however, using it inside of stored procedures can be complicated

Revisiting the concept of SQL Table Size Calculation using new SQL features