This Blog Is Dead - Dead I tell you!

This blog has been decommissioned - thank you, Mr. Blog, for all of your hard work.

Seriously - this is a dead blog now so unsubscribe. Move your subscriptions to our 'One Blog': <a href="http://www.learnitfirst.com/blogs/NewVideos/">The one, big New Videos blog</a>

For full details on what's going down, check out <a href="http://www.learnsharepoint.com/NewsItem.aspx?nid=55">http://www.learnsharepoint.com/NewsItem.aspx?nid=55

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...

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 400 (Intermediate - Advanced)
• Length: 6:15 (6.02MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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

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.'

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 300 (Intermediate)
• Length: 11:00 (9.39MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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,

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

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 300 (Intermediate)
• Length: 11:45 (11.2MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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,

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.

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 300 (Intermediate)
• Length: 16:30 (12.8MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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

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!

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 300 (Intermediate)
• Length: 10:05 (7.84MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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

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.

---

• Source: http://www.LearnTransactSQL.com
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 300 (Intermediate)
• Length: 13:40 (11.2MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

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