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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-05 : 08:32:02
|
| Mushtaq writes "Hi, Could you please give me reference for multiuser database programming. Basically I want help on database locking mechanism. I went through internet but i couldn't get proper solution. Finally i came to this site for solution. Please help me. what are the things should be considered in multiuser programming ? How to handle insertion of records at simultaneously ? And I have one field as primary key (datatype is integer and IDENTITY)for my registration form.I am able to enter the data properly. My doubt is, if my data crosses the integer limit (10 digits in length), what should i do ? Could you please help me.Thanks in advanceMushtaq" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-09-05 : 09:16:45
|
| Which RDBMS are you using?You mention IDENTITY, so I assume its SQL Server. Transaction integrity is a requirement for a Relational System, so it's built in to SQL Server. There is plenty to read in Books Online to get more detailed information.If you have more than 4.2 billion registrants, then you should use a different datatype for your primary key ....Jay White{0} |
 |
|
|
|
|
|
Help me on multiuser database programming ....