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 |
|
raziku
Starting Member
2 Posts |
 Posted - 2007-01-02 : 15:56:06
|
| Hi there!I am building an application that counnts clicks on an ad. I use the integer field to count them but someone told me there is a limit number this field can count - is that correct? if so, is there a solution for my problem?Thanks and happy 2007!R |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2007-01-02 : 15:58:54
|
| Yes an int is limited something like 2,100,000,000. If you think someone will be clicking more than that you can use a bigint. Check out datatypes in BOL. |
 |
|
|
raziku
Starting Member
2 Posts |
Posted - 2007-01-02 : 16:02:17
|
| Thanks! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-02 : 17:39:03
|
| If you use INT, there has to be 1,000 clicks per second for 49 days around the clock.Or 100 clicks per second for 497 days.Or 10 clicks per second for 13.5 years.Or 1 click per second for 136.1 years.Using BIGINT, there has to be 1,000,000 clicks per second for 584,554 years.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Integer question