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 - 2000-10-25 : 16:29:55
|
Dan writes "Hello,
How would you go about writing a sql statement or stored procedure that would return a specified number of records from a table. At the same time the records returned would have to be updated to let anyone else checking records out that they were already taken.
I was going to just use to sql statements select the records, then update the selected records but then I could run into problems. If two people check out the same records and then went to update they could overwrite each other.
Thanks,
Dan" |
|
|
|
|
|
Checking Out/In Records