Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Video Rss

   Items 1 to 8 of 8   
 

Using the Union Statement - SQL School Video

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...
By Andy Warren 2009/03/24 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 6,634 reads

Using Intersect - SQL School Video

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...
By Andy Warren 2009/03/17 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,684 reads

Using Views and Synonyms for Abstraction - SQL School Video

In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.  Read more...
By Brian Knight 2009/01/22 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,292 reads

Generating Random Results - SQL School Video

How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.  Read more...
By Andy Warren 2009/01/15 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,127 reads

Using the CheckSum Function - SQL School Video

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...
By Brian Knight 2008/12/18 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,869 reads

Bypassing a Trigger - SQL School Video

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...
By Andy Warren 2008/12/16 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,298 reads

Modifying Data - SQL School Video

MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.  Read more...
By Kathi Kellenberger 2008/09/30 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,629 reads

Summarizing Data with Aggregate Queries - SQL School Video

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...
By Kathi Kellenberger 2008/08/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,819 reads
   Items 1 to 8 of 8   
 
Tags
aggregates (1)    
checksum (1)    
intersect (1)    
random (1)    
synonyms (1)    
triggers (1)    
union (1)    
views (1)