Mensaje
De
09/03/2010 04:16:19
a
Todos
General information
Foro:
Microsoft SQL Server
Category:
Sintáxis SQL
Título:
Record locking
Miscellaneous
ID de la conversación:
01453377
ID del mensaje:
01453377
Views:
95
Hi
What's the best way to lock a specific record within a stored procedure? I have 3 fields in my table called LockedBy (char 64), LockedByID (int 10) and LockedByDateTime (smalldatetime). When I perform a record lock I'd like to update those fields in the table so that any other calling procedure can see who has locked the record and when.
Obviously, within my SQL stored procedure I'd need to pass in the LockedBy and LockedByID values, attempt a record lock, update the 3 fields, then finally I'd remove the record lock. The reason I don't want to let SQL continue to lock the record is because the user may have the record open for 60 minutes, so by using these 3 fields I can check if a record has been locked just by interrogating those fields. Once the user has finished with the record I would just do a reverse of the process.
What's the best way to go about this?
Regards
What's the best way to lock a specific record within a stored procedure? I have 3 fields in my table called LockedBy (char 64), LockedByID (int 10) and LockedByDateTime (smalldatetime). When I perform a record lock I'd like to update those fields in the table so that any other calling procedure can see who has locked the record and when.
Obviously, within my SQL stored procedure I'd need to pass in the LockedBy and LockedByID values, attempt a record lock, update the 3 fields, then finally I'd remove the record lock. The reason I don't want to let SQL continue to lock the record is because the user may have the record open for 60 minutes, so by using these 3 fields I can check if a record has been locked just by interrogating those fields. Once the user has finished with the record I would just do a reverse of the process.
What's the best way to go about this?
Regards