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.
Runtime: 1:38 minutes
|
| |
These videos are provided by JumpstartTV and End to End Training
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.
2009-03-24
6,808 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,391 reads
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,179 reads
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.
2008-12-18
6,111 reads
Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
2008-12-16
4,386 reads
