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.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2006-07-27 : 10:02:19
|
| Guys,What is the maximum value that a column with datatype INT and BIGINT can hold??Thanks |
|
|
Q
Yak Posting Veteran
76 Posts |
Posted - 2006-07-27 : 10:10:17
|
| int, bigint, smallint, and tinyintExact number data types that use integer data.bigintInteger (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Storage size is 8 bytes.intInteger (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.smallintInteger data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes.tinyintInteger data from 0 through 255. Storage size is 1 byte. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-27 : 10:37:33
|
| Read about datatypes in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-27 : 10:43:20
|
quote:
Originally posted by scelamko
Guys,What is the maximum value that a column with datatype INT and BIGINT can hold??Thanks
look that up in BOL or google it. -ec |
|
|
|
|
|
|
Datatype: INT Vs BIGINT