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 |
|
naruponk
Starting Member
1 Post |
 Posted - 2010-10-09 : 03:43:49
|
Hi,I have a table named as poThis table has the following columns:ID (auto number), pono, podate,membercode15 computers will query the last number of po.ponosome time 2-3 computers will get the same numberof max(pono)I have added the Begin Trans / Commit Trans in my programto avoid for getting the same number.But they still get the same number  How can I do to get unique number as result? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-10-09 : 13:43:44
|
| is the nature of your table PO that everytime query is run against this table (regardless of number of computers) one should get different results?after reading your problem i assume users are getting the correct data returned from the table, because data stored in table are not getting any new values.Usually when a simple select is run against the table it locks the table in order to get correct results (and avoid dirty reads). |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Best way to select max auto number ?