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 |
|
john.lam
Starting Member
12 Posts |
 Posted - 2009-12-23 : 07:54:57
|
| Hi all,I have a table (table A) with an id field where the value in this field will be retrieved from an id field in other table (table B). If I insert a new record in table A, the id field in table B will increase by 1. My problem is, I want a way to make sure no same value will be retrieved by table A, especially if there are more than 1 process are running at the same time. How can I achieve this requirement?Thanks.John Lam |
|
|
|
|
|
Insert record