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 |
|
mushtaq
Starting Member
2 Posts |
 Posted - 2002-09-02 : 03:55:23
|
| Hi, I am developing application in visual basic. I have one primary field (datatype is integer). I am able to insert the values properly in the table. My problem is, integer limit is (10 digits in length), if my value crosses that limit over period of time. How should I take care of that issue ? Could you please help me in this issue.Thanks in advanceMushtaq |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-09-02 : 04:28:27
|
| Hi Mushtag!There are many different data types in SQL server you can take as an option for holding a primary key value. I prefer INT, but if you look at BOL you'll see that there are many types of INT (uaauu...!). If INT can't do the job, take BIGINT... |
 |
|
|
|
|
|
Primary key issue?