Friday, May 29, 2009

New SQL Server Programming Video Tutorial: The Basics of the HAVI NG Clause

The Basics of the HAVING Clause - view details
In this essential video tutorial, Scott Whigham will explain to you what exactly the HAVING clause specifically, and define the HAVING clause, which isone of two filters you can use in your queries.

Highlights from this video:
  • What can the HAVING clause filter?
  • Working with the HAVING clause
  • Specific places to use HAVING clause
and much more!���� ��
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: having clause, about having clause

posted by Scott Whigham @ 11:34 AM  

New SQL Server Programming Video Tutorial: What Are Computed Colu mns (a.k.a. Derived Fields)? When Should I Use Them?

What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them? - view details
Do you find yourself constantly copying and pasting a specially formatted column name or expression multiple times? In this video tutorial Scott Whigham will show you how you can re-use your code via a computed column.
Highlights from this video:
  • About data storage in a computed column
  • Can you modify a computed column?
  • When to use a computed column
  • Advantages of a derived field/computed column
and much more!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: computed column, derived field,

posted by Scott Whigham @ 11:34 AM  

New SQL Server Programming Video Tutorial: What is Context_Info?

What is Context_Info? - view details
Context_Info is a new concept for sql server that provides us with a way to store data for the entire duration of the session. In this video tutorial, Scott will divulge the purpose and techniques for working with Context_Info, as well as show you some great examples of using Context_Info.

Highlights from this video:
  • Context_info vs Variables
  • Using the context_info function
    • syntax
    • techniques
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: context_info, variable,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 11:34 AM  

New SQL Server Programming Video Tutorial: A Comparison of DISTIN CT and GROUP BY: When to Use Each

A Comparison of DISTINCT and GROUP BY: When to Use Each - view details
In this video tutorial Scott Whigham will breakdown the differences and similarities between using the DISTINCT and GROUP BY clauses.

Highlights from this video:
  • Where do these clauses respectively operate?
  • What kind of relationships are drawn between base table and your result set?
  • Purpose of GROUP BY and DISTINCT and how SQL Server treats them
  • Comparing/Contrasting the two clauses
and much more!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: distinct, group by, clause,

posted by Scott Whigham @ 11:34 AM  

New SQL Server Programming Video Tutorial: TOP Operator: What's N ew and Why Life Is much Easier Today

TOP Operator: What's New and Why Life Is much Easier Today - view details
The TOP operator has been greatly enhanced over SQL Server 2000's implementation of TOP by adding support for parameterization and the ability to use TOP in all DML statements (instead of just the SELECT). Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through using the new features of TOP and how it differs from previous versions.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: new feature, top parameter, insert, update, delete, select

posted by Scott Whigham @ 11:34 AM