Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

Data Type Overview - Order of Precendence, Using CAST and CONVERT, and Best Practices for Data Type Conversion (Video Series)

Video Image Video Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
All SQL developers should have command of the datatype conversion functions, CAST and CONVERT. All SQL developers should also have full knowledge of the data types themselves (i.e., which holds a larger number, FLOAT or REAL?).

This video series helps you cope with the various data types as well as helping you learn how implicit and explicit datatype conversion works (i.e., converting from a string to a number) and much, much more.

Videos in this Series:

TitleSkillLengthDownload
01 - An Introduction to Datatype Conversion   200 11 mins. Download
02 - Implicit Datatype Conversion and How SQL Server Converts Data in Expression...   200 11 mins. Download
03 - More on Datatype Conversions with ISNUMERIC and ISDATE   300 8 mins. Download
04 - Working With Decimal-Based Datatypes: MONEY, DECIMAL, FLOAT, et al   300 14 mins. Download
05 - Working With Integer Data   300 10 mins. Download
06 - Explicit Datatype Conversion Using CAST and CONVERT   300 17 mins. Download
07 - More on Using CAST and CONVERT to Do Datatype Conversion   300 12 mins. Download
08 - Understanding Datatype Precedence in Implict Conversions   300 11 mins. Download
09 - Best Practices, Writing CASE Statements, and Final Thoughts   400 6 mins. Download
10 - Final, Final Thoughts   400 7 mins. Download

Miscellaneous Bits & Pieces:
Helpful Keyboard Shortcuts: "ALT" + "TAB" allows you to cycle through the Taskbar items
Book You Should Probably Own: Brian Knight's "Professional SQL Server 2005 Integration Services"
SQLDIAG.EXE is a handy tool that ships with your SQL Server that can provide you with detailed information about your SQL Server and its environment. Simply run SQLDIAG.EXE from the command-line

Other Websites We Offer
LearnCSharp.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/8/2009 2:58:56 PM