General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
Hi,
I locked a records on the sql using the following statement :-
begin transaction
select item_no,itemdesc
from ims.item [rowlock] with (xlock)
where item_no = '0200200008' or item_no = '3336512009'
after that i want to unlock one of the item and keep locking the others.
Best Regards
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only