Easy urgent 500 pts question select+update
Posted on 2005-05-02
Hi to all...
I would like to select a row from a table and apdate a LockID field in the same row....
select @PartnerID=PartnerID from tblPartners where PartnerState=1
update tblPartners set LockID=1 where PartnerID=@PartnerID
my main problem is, that another sp may change the PartnerState of the row AFTER the select and BEFORE the update...
is there any way to make an update and the select TOGETHER???