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 |
|
tariq2
Posting Yak Master
125 Posts |
 Posted - 2012-04-11 : 11:16:59
|
| Hi, I have an int field in a table and obviously the maximum amount it takes is (2,147,483,647)But I have to try and insert the following:4,552,500,600What ought I do regarding the field?Does this now need to become a bigint? |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-04-11 : 11:25:39
|
| Change the field to BIGINT which gives you 9,223,372,036,854,775,807JimEveryday I learn something that somebody else already knew |
 |
|
|
tariq2
Posting Yak Master
125 Posts |
Posted - 2012-04-11 : 11:26:05
|
| Thank you |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-04-11 : 11:26:38
|
| You're welcome.JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
field size