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 |
|
olily
Starting Member
37 Posts |
 Posted - 2002-08-15 : 01:20:58
|
| I just wondering about Identity field. What is the maximum number that it can reach? Will it reset automatically? I'm asking because I plan to set a column as Identity but considering that the data will grows very fast, I don't whether should I use Identity.Or is the any way that I can use to differentiate every row is unique but a dummy field? The field won't have any significant other than present as unique key. Please advice. |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-08-15 : 02:25:02
|
| The maximum number depends on the numeric data type which you chose.You can use timestamp, unique identyfier for uniqueness, for details refer BOL---------------------------Sandesh - The Messanger |
 |
|
|
|
|
|
QUESTION ON IDENTITY FIELD