In this article look at a couple examples and compare a correlated sub query to a join.

In this puzzle, we’re going to learn how to rewrite a subquery using inner joins.

Implicit data conversion Implicit conversions are those conversions that occur automatically whenever the CAST or CONVERT functions aren’t used.  Not all values can be implicitly converted to another data type.

After reading this article you will understand what a database cursor is, see an example, and understand when to use them in a stored procedure.

Bring your animations to H264/HEVC video using C++ and C# with h/w acceleration

Puzzle to explore a SQL BOM example

How to use SQL GROUP BY Clause is to consolidate like values into a single row

In this blog entry we discuss the difference between left join versus right join operators.