Tuesday, April 24, 2007

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

09 - 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...
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: CASE, Searched case, boolean case, selector case

posted by Scott Whigham @ 6:42 PM   0 comments  

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

08 - 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, 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: converting datatypes, data types, convert date to string, convert date to characters, formatting, format dates, reports, report,

posted by Scott Whigham @ 6:42 PM   0 comments  

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

07 - 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, 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: converting datatypes, data types, convert date to string, convert date to characters, formatting, format dates, reports, report,

posted by Scott Whigham @ 6:42 PM   0 comments  

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

06 - 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 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: converting datatypes, data types, convert date to string, convert date to characters

posted by Scott Whigham @ 6:41 PM   0 comments  

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

05 - 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, 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: int, integer, int32, uint, long,. short, int32, int6, 4tinyint, bit, smallint, bigint

posted by Scott Whigham @ 6:41 PM   0 comments  

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

04 - 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, 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: precision, scale, decimal places, floating point arithmetic

posted by Scott Whigham @ 6:41 PM   0 comments  

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

03 - 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, 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: 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 @ 6:41 PM   0 comments  

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

02 - 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, 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: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 6:41 PM   0 comments  

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

01 - 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, 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: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 6:41 PM   0 comments  

New Transact SQL Video Tutorial: How to Get the Most Out of SSMS: Understanding the Tabbed Environment

How to Get the Most Out of SSMS: Understanding the Tabbed Environment - view details
How to Get the Most Out of SSMS: Understanding the Tabbed Environment
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: How to Get the Most Out of SSMS: Understanding the Tabbed Environment, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 6:35 AM   0 comments  

Monday, April 23, 2007

New Transact SQL Video Tutorial: Pt. 2 - Writing Queries Using the SQL Server Management Studio (SSMS)

Pt. 2 - Writing Queries Using the SQL Server Management Studio (SSMS) - view details
Pt. 2 - Writing Queries Using the SQL Server Management Studio (SSMS)
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: Pt. 2 - Writing Queries Using the SQL Server Management Studio (SSMS)

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS - view details
Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS
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: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log - view details
Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log
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: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause)

Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause) - view details
Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause)
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: Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause)

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

Pt. 1 - An Introduction to SQL Server Management Studio (SSMS) - view details
Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)
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: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements

Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements - view details
Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements
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: Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements

posted by Scott Whigham @ 10:35 AM   0 comments  

New Transact SQL Video Tutorial: Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries)

Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries) - view details
Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries)
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: Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries)

posted by Scott Whigham @ 10:35 AM   0 comments  

Sunday, April 22, 2007

New Transact SQL Video Tutorial: Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL

Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL - view details
Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL
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: Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL

posted by Scott Whigham @ 6:28 AM   0 comments