Overview of SQL Server Data Types: Numbers

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
681 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Dec 25, 2010

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

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • i have watched many sql videos but this is the best one.. nice work

    thank you so much..

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more