SQL

SQL 2008 made it easy, but in SQL Server 2005, how do you find out the modified date to identify changes?

Part III of the series continues to look at retrieving database records. This article covers the use of the LIKE, BETWEEN, IN and HAVING commands.

This article covers ways of inserting, manipulating and removing data from your SQL database using the INSERT INTO, SELECT INTO, UPDATE and DELETE commands.

This tutorial looks at the various ways of table manipulation within SQL. The CREATE, UPDATE and DROP TABLE commands are covered.

An introduction to the SQL. This article includes the basics on retrieving records from your SQL database using the SELECT, WHERE, AND and OR keywords.

Part II of the series looking at the retrieving database records. This article covers the use of the ORDER BY, GROUP BY, SUM, AVG, MIN, MAX, COUNT, DISTINCT and TOP commands.

This article covers the basics of the various join types in SQL. With explanations and examples of INNER, OUTER, LEFT and RIGHT joins as well as the UNION command this should be the ideal resource to get you started.