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 - 2003-01-06 : 09:46:39
|
| masood writes "I have centerlized SQL 2K database on SERVR and multiple user accessing it from different locations(LAN).Two or more user access one Table Tyr to add new record in a Table,Table has Iddentity column as primary key User 1 is still Adding Data from FrontEND did not pressed Insert button to insert the value into table User 2 Added data in frontEnd form and Insert the record as well.In this case how proper Autonember will be asiigned to records.What Cursor Type of ADO i should use for efficient results as well in above case?" |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-06 : 10:03:28
|
| What purpose does your identity column have (application speaking - like number for a document,position numbering,etc.)? |
 |
|
|
|
|
|
Query about INSERT or Update in Mutiuser Envoirnment?