Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking 1

Status
Not open for further replies.
hmckillop

hmckillop

Programmer
Oct 30, 2001
1,540
GB
If I use a rowlock hint, will this lock the associated row for the duration of the transaction
i.e
Begin Tran
SELECT @v_Count = COUNT(*)
FROM Template tpt (ROWLOCK)
WHERE tpt.OID = @pi_TemplateOID

...other sql statements
Commit tran

Thanks
 
Sort by date Sort by votes
Hi !
Begin Tran
SELECT @v_Count = COUNT(*)
FROM Template tpt (ROWLOCK, HOLDLOCK)
WHERE tpt.OID = @pi_TemplateOID

...other sql statements
Commit tran
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

malaygal
  • Locked
  • Question
Locking row from a view
Replies
1
Views
57
NoCoolHandle
NoCoolHandle
mdav2
  • Locked
  • Question
Record level locking on a table
Replies
8
Views
64
gmmastros
gmmastros
FengShui1998
  • Locked
  • Question
Record locking
Replies
5
Views
56
markros
markros
123FakeSt
  • Locked
  • Question
TRY CATCH locking up sysobjects table
Replies
2
Views
42
123FakeSt
123FakeSt
juddymar58
  • Locked
  • Question
Access / SQL Server locking procedure
Replies
3
Views
56
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top