Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

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

Does anybody have or know of a list of the different SQL Data Types and how many bytes they take up.
0
Mr_Shaw
Asked:
Mr_Shaw
5 Solutions
 
EvilPostItCommented:
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
 
Lee SavidgeCommented:
select xtype, length from systypes

Lee
0
 
loopfinityCommented:
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Pratima PharandeCommented:
0
 
Mr_ShawAuthor Commented:
select xtype, length from systypes


Is length the number of bytes.
0
 
Lee SavidgeCommented:
Yes. The query is this: select name, length from systypes

I chose the wrong column.

Lee
0
 
Mr_ShawAuthor Commented:
Thanks....  systypes is very useful...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now