storage precision - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

storage precision

Author

Topic

phaze
Starting Member

42 Posts

Posted - 2005-03-23 : 12:25:58

What are the storage precisions for data types int, smallint, and tinyint?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-23 : 12:29:35

emm.... storage precisions???
what kind of storage precision are ytalking about in an int datatype???

Go with the flow & have fun! Else fight the flow

phaze
Starting Member

42 Posts

Posted - 2005-03-23 : 12:32:51

I am stumped on that as well. I believe it is asking for the storage size?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-23 : 12:33:35

who's asking?

Go with the flow & have fun! Else fight the flow

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-23 : 12:35:35

from BOL:


bigint
   Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Storage size is 8 bytes.

int
   Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-
   92 synonym for int is integer.

smallint
   Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes.

tinyint
   Integer data from 0 through 255. Storage size is 1 byte.

Go with the flow & have fun! Else fight the flow

phaze
Starting Member

42 Posts

Posted - 2005-03-23 : 12:41:59

well if you really wanna know..i got this test at work that is given to senior level positions and they asked me to find the answers to them so that they can use it to interview people.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-03-28 : 03:37:00

so that's how you get promoted to senior position

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources