?
Solved

Does anybody have or know of a list of the different SQL Data Types and how many bytes they take up.

Posted on 2011-02-15
7
Medium Priority
?
836 Views
Last Modified: 2012-05-11
Does anybody have or know of a list of the different SQL Data Types and how many bytes they take up.
0
Comment
Question by:Mr_Shaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 300 total points
ID: 34895717
Here is the link.

From this page you can access each data type which includes the size

http://msdn.microsoft.com/en-us/library/ms187752.aspx
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 1100 total points
ID: 34895718
select xtype, length from systypes

Lee
0
 
LVL 6

Assisted Solution

by:loopfinity
loopfinity earned 300 total points
ID: 34895721
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 300 total points
ID: 34895804
0
 

Author Comment

by:Mr_Shaw
ID: 34895883
select xtype, length from systypes


Is length the number of bytes.
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 1100 total points
ID: 34895952
Yes. The query is this: select name, length from systypes

I chose the wrong column.

Lee
0
 

Author Closing Comment

by:Mr_Shaw
ID: 34898376
Thanks....  systypes is very useful...
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question