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!

Using UPDLOCK or ROWLOCK

Status
Not open for further replies.
inhisglory

inhisglory

Programmer
Jul 8, 2001
10
ID
which better using UPDLOCK or ROWLOCK for insert record in sqlsever 7.

How about delete and update ?

Thank you for helping me

Inhisglory
 
Sort by date Sort by votes
None of the above. There is rarely a need to explicitly lock a recod in sql server.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
234
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
152
Auguy
Auguy
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
160
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
156
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
147
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top