This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:
http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx?an=YouTube
In this video, Scott will start with integer-based numbers, and then move into decimal-based numbers. How many bytes does it take to represent each basic integer data type? To demonstrate decimal-based numbers, money is used as the example. When a number is too long, unlike when a string is too long, Management Studio will return an overflow error instead of truncating. Scott discusses how to specify the number of digits and decimal places in the output, and more in this video.
Highlights from this video:
* INT, TINYINT, SMALLINT, and BIGINT
* The DATALENGTH function
* What if your business operates using less than 4 decimal places?
* Using FLOAT
and much more
i have watched many sql videos but this is the best one.. nice work
thank you so much..
ssinghmann 1 year ago