SQLServerCentral.com Articles tagged Video, T-SQL

Using the Union Statement - SQL School Video

Tue, 24 Mar 2009 06:00:00 UT

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.

Using Intersect - SQL School Video

Tue, 17 Mar 2009 06:00:00 UT

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.

Using Views and Synonyms for Abstraction - SQL School Video

Thu, 22 Jan 2009 07:00:00 UT

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

Generating Random Results - SQL School Video

Thu, 15 Jan 2009 07:00:00 UT

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

Using the CheckSum Function - SQL School Video

Thu, 18 Dec 2008 07:00:00 UT

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.

Want faster, smaller backups you can rely on?
Use SQL Backup Pro for up to 95% compression, faster file transfer and integrated DBCC CHECKDB. Download a free trial now.

Bypassing a Trigger - SQL School Video

Tue, 16 Dec 2008 07:00:00 UT

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

Modifying Data - SQL School Video

Tue, 30 Sep 2008 06:00:00 UT

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

Summarizing Data with Aggregate Queries - SQL School Video

Thu, 28 Aug 2008 06:00:00 UT

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.