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

---

• Source: Transact SQL videos
• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 400 (Intermediate - Advanced)
• Length: 7:11 (6.64MB)
• Applies to Versions: SQL Se rver - All Versions
• Full Details

---

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