In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
Runtime: 3:21 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,801 reads
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.
2009-03-17
4,837 reads
New in SQL Server 2005, Synonyms replace aliases from previous versions. Brian Knight shows how they can be created and used.
2009-01-20
2,696 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,102 reads
