Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL 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:
Keyboard Shortcut for SQL Server Management Studio: SHIFT+F10 displays the context menu
Want to see what's going on in your log? Run DBCC log (<insert your database name here >) WITH TABLERESULTS
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons

Other Websites We Offer
LearnCSharp.com
Don't Forget!
Become a Guru
 
   
 
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!
 
11/20/2008 6:36:26 PM