The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. Learn how to use it and see a range of examples in this guide.

Read More

Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide.

Read More

Do you need to convert data in SQL Server? Looking for the format codes for the CONVERT function? Learn all about the SQL Server CONVERT function in this guide.

Read More

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

Read More

Learn all about the SQL Alter Table statement.

Read More

The SQL COUNT function is one of the most common functions used by SQL developers. I use it on a daily basis. Learn more about the COUNT function in this article.

Read More

Learn how to drop tables in SQL.

Read More

The SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. Learn more about this powerful statement in this article.

Read More

Learn how to use the SQL INSERT INTO command.

Read More

The SQL DELETE statement allows you to delete records from a table. I'll explain more about the SQL DELETE statement in this article.

Read More