Video 1: Row Constructors
(Running Time: 5:08)
|
|
In this video, you will learn how to use Row Constructors, which
is a new T-SQL enhancement included with SQL Server 2008. Row Constructors
allow you to enter multiple records into a table using a single
INSERT Statement.
Video 2: Merge Statement
(Running Time: 16:21)
|
|
This MERGE statment allows you to INSERT, UPDATE, or DELETE
records on one table, based on the results of a join with another table.
This video will show you how to take advantage of this new T-SQL command
and walk you through a detailed example to demonstrate its use.
Video 3: Grouping Sets
(Running Time: 7:36)
|
|
This video will demonstrate how to use Grouping Sets, which is another
T-SQL enhancement that will be introduce with SQL Server 2008.
This feature adds more functionality to the existing GROUP BY clause and
lets you perform grouping on multiple groups within the same SQL Statement.
Video 4: Date and Time Data Types
(Running Time: 6:38)
|
|
SQL Server 2008 includes four new data types to work with date and time data! This video will
walk you through examples of how to use the DATE, TIME, DATETIME2 and DATETIMEOFFSET data types that
will be introduced.
Video 5: HierarchyID Data Type
(Running Time: 21:13)
|
|
This video will demonstrate how to use the new HierarchyID Data Type
introduced with SQL Server 2008. This new data type is a System Data Type used for
hierarchical data.
Video 6: Table-Valued Parameters
(Running Time: 7:41)
|
|
This video will provide an introduction to User-Defined Tables and Table-Valued Parameters which will
be included with SQL Server 2008. You will see how to use this new functionality to send multiple
rows of data into a stored procedure!