In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.  Read more...

This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.  Read more...

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.  Read more...

How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.  Read more...

There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.  Read more...

Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.  Read more...

MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.  Read more...

Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.  Read more...