Tuesday, March 27, 2007

New Transact SQL Video Tutorial: Pt. 7 - Column Aliases, TOP, and ORDER BY

Pt. 7 - Column Aliases, TOP, and ORDER BY - view details
Pt. 7 - Column Aliases, TOP, and ORDER BY
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 7 - Column Aliases, TOP, and ORDER BY

posted by Scott Whigham @ 5:52 AM   0 comments  

Tuesday, March 20, 2007

New Transact SQL Video Tutorial: Pt. 5 - When to Use GROUP BY, DISTINCT, and An Overview of Aggregates in SQL

Pt. 5 - When to Use GROUP BY, DISTINCT, and An Overview of Aggregates in SQL - view details
Pt. 5 - When to Use GROUP BY, DISTINCT, and An Overview of Aggregates in SQL
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 5 - When to Use GROUP BY, DISTINCT, and An Overview of Aggregates in SQL

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - Discussion of the Various Syntaxes for the INSERT Statement

Pt. 2 - Discussion of the Various Syntaxes for the INSERT Statement - view details
Pt. 2 - Discussion of the Various Syntaxes for the INSERT Statement
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 2 - Discussion of the Various Syntaxes for the INSERT Statement

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - Using the SELECT Statement With and Without a FROM Clause

Pt. 2 - Using the SELECT Statement With and Without a FROM Clause - view details
Pt. 2 - Using the SELECT Statement With and Without a FROM Clause
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 2 - Using the SELECT Statement With and Without a FROM Clause

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 1 - An Overview of the INSERT Statement in Transact SQL

Pt. 1 - An Overview of the INSERT Statement in Transact SQL - view details
Pt. 1 - An Overview of the INSERT Statement in Transact SQL
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 1 - An Overview of the INSERT Statement in Transact SQL

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 4 - INSERTs and Identity Columns: An Overview

Pt. 4 - INSERTs and Identity Columns: An Overview - view details
Pt. 4 - INSERTs and Identity Columns: An Overview
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 4 - INSERTs and Identity Columns: An Overview

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 6 - Using HAVING and GROUP BY

Pt. 6 - Using HAVING and GROUP BY - view details
Pt. 6 - Using HAVING and GROUP BY
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 6 - Using HAVING and GROUP BY

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 3 - Writing WHERE Clauses and Filtering Your Data

Pt. 3 - Writing WHERE Clauses and Filtering Your Data - view details
Pt. 3 - Writing WHERE Clauses and Filtering Your Data
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 3 - Writing WHERE Clauses and Filtering Your Data

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 4 - Complex WHERE Clauses Using AND, OR, and Parentheses

Pt. 4 - Complex WHERE Clauses Using AND, OR, and Parentheses - view details
Pt. 4 - Complex WHERE Clauses Using AND, OR, and Parentheses
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 4 - Complex WHERE Clauses Using AND, OR, and Parentheses

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence

Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence - view details
Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence

posted by Scott Whigham @ 4:32 PM   0 comments  

New Transact SQL Video Tutorial: Pt. 3 - Inserting Data Into Tables With Constraints

Pt. 3 - Inserting Data Into Tables With Constraints - view details
Pt. 3 - Inserting Data Into Tables With Constraints
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: Pt. 3 - Inserting Data Into Tables With Constraints

posted by Scott Whigham @ 4:32 PM   0 comments  

Wednesday, March 07, 2007

New Transact SQL Video Tutorial: 9 - Best Practices, Writing CASE Statements, and Final Thoughts

9 - Best Practices, Writing CASE Statements, and Final Thoughts - view details
Originally when Scott Whigham (author of this site) recorded this series, this video was supposed to be the last video...
T o download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: CASE, Searched case, boolean case, selector case

posted by Scott Whigham @ 5:55 AM   0 comments  

New Transact SQL Video Tutorial: 10 - Final, Final Thoughts

10 - Final, Final Thoughts - view details
Which one of the following SQL expressions will produce the correct answer to the division of 23 by 22 (should be 1.045...)?
  • SELECT 23/22
  • SELECT CAST(23/22 AS DECIMAL)
  • SELECT CAST(23/22 AS FLOAT)
Answer? None of the above! Watch this video to find out the answer...
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: converting datatypes, data types, convert date to string, convert date to characters

posted by Scott Whigham @ 5:55 AM   0 comments  

New Transact SQL Video Tutorial: 8 - Understanding Datatype Precedence in Implict Conversions

8 - Understanding Datatype Precedence in Implict Conversions - view details
SQL Server has a specific set of rules that it follows when it does implicit conversion. These rules are outlined in this video and you get to see interesting examples.

A note from Scott Whigham (author): 'I consider this information extremely important and I heartily recommend that you commit these examples to memory.'
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: converting datatypes, data types, convert date to string, convert date to characters, formatting, format dates, reports, report,

posted by Scott Whigham @ 5:55 AM   0 comments  

New Transact SQL Video Tutorial: 7 - More on Using CAST and CONVERT to Do Datatype Conversion

7 - More on Using CAST and CONVERT to Do Datatype Conversion - view details
This is a continuation from Part 6 and this video focuses on the proprietary options of the CONVERT (such as the style parameter) to format dates
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: converting datatypes, data types, convert date to string, convert date to characters, formatting, format dates, reports, report,

posted by Scott Whigham @ 5:55 AM   0 comments  

New Transact SQL Video Tutorial: 4 - Working With Decimal-Based Datatypes: MONEY, DECIMAL, FLOAT, et al

4 - Working With Decimal-Based Datatypes: MONEY, DECIMAL, FLOAT, et al - view details
What are the differences between MONEY and SMALLMONEY? FLOAT and REAL? DECIMAL and NUMERIC? That much and more is covered in this video.
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: precision, scale, decimal places, floating point arithmetic

posted by Scott Whigham @ 5:54 AM   0 comments  

New Transact SQL Video Tutorial: 6 - Explicit Datatype Conversion Using CAST and CONVERT

6 - Explicit Datatype Conversion Using CAST and CONVERT - view details
This video covers the various options for doing explicit datatype conversion so that you can control the datatypes in your expressions.
To down load this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: converting datatypes, data types, convert date to string, convert date to characters

posted by Scott Whigham @ 5:54 AM   0 comments  

New Transact SQL Video Tutorial: 5 - Working With Integer Data

5 - Working With Integer Data - view details
What is the result of running the SQL statement 'SELECT 23/22'? If you said '1', you are correct! does that surprise you? It shouldn't and, if it does, you really should watch this video!
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: int, integer, int32, uint, long,. short, int32, int6, 4tinyint, bit, smallint, bigint

posted by Scott Whigham @ 5:54 AM   0 comments  

New Transact SQL Video Tutorial: 3 - More on Datatype Conversions with ISNUMERIC and ISDATE

3 - More on Datatype Conversions with ISNUMERIC and ISDATE - view details
This video covers the functions ISNUMERIC() and ISDATE() with an interesting demo on how to use these to avoid SQL syntax errors.
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: This video covers the various options for doing explicit datatype conversion so that you can control the datatypes in your expre

posted by Scott Whigham @ 5:54 AM   0 comments  

New Transact SQL Video Tutorial: 2 - Implicit Datatype Conversion and How SQL Server Converts Data in Expressions

2 - Implicit Datatype Conversion and How SQL Server Converts Data in Expressions - view details
This video is all about how SQL Server can automatically (implicitly) convert datatypes in expressions. For example, in the expression 'SELECT 1 + 10000 + 0.00', what will the return datatype be? 1 could be a BIT, a TINYINT, a SMALLINT, an INT, or a BIGINT - which is it? 10000 could be a SMALLINT, INT or BIGINT. 0.00 could be a DECIMAL, NUMERIC, FLOAT, REAL, MONEY, or SMALLMONEY.

Highlights from this video:
  • In the expression, SELECT '123', is '123' a string or a number?
  • In the expression, SELECT 2007/08/08, is the return type an INT, a DECIMAL, or a DATETIME?
an much more on datatypes

So what is the answer to our question above? The answer is that if you just typed that expression in, your return type would be a FLOAT.
To download this video, Login, then visit the video's detail page and click "download". This is a subscribe r-only video so a subscription is required.

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

Keywords Associated with this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 5:54 AM   0 comments  

New Transact SQL Video Tutorial: 1 - An Introduction to Datatype Conversion

1 - An Introduction to Datatype Conversion - view details
Datatype conversion is what we, as developers, have to deal with on a daily basis. No matter what the language, data type conversion is a daily event. This video helsp introduce the concept from a SQL Server-specific standpoint.

Highlights from this video:
  • Overview of the various datatypes available in SQL Server
    • Numbers
    • Strings
    • Dates
  • Differences between various datatypes
  • Using 'SELECT 123' statements and how SQL Server implements such queries
  • How SQL Server performs datatype conversions in expressions
and much more
To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

Keywords Associated with this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 5:54 AM   0 comments