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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock record by SQL

Status
Not open for further replies.
JimmyK

JimmyK

Programmer
Sep 8, 2000
142
VN
Hi,
please tell me how to lock a record in SQL Server 7.0.
In Oracle, we have a SQL like this
Select * from Emp for update it'll lock all record selected.
Is there anything equivalent in SQL Server 7.0?
Thank a lot Jimmy Le
nhan_tiags@yahoo.com
 
Status
Not open for further replies.

Similar threads

rbeitler
  • Locked
  • Question
VFP File Lock Issues with Windows Server 1
Replies
10
Views
1K
Chris Miller
Chris Miller
GTGeek88
  • Locked
  • Question
SQL query syntax
Replies
7
Views
483
GTGeek88
GTGeek88
rbeitler
  • Locked
  • Question
Command History not saved if VFP closed by shutdown
Replies
13
Views
748
Chriss Miller
C
I
  • Locked
  • News
Some projects compiled by Net run in VFP 1
Replies
10
Views
1K
iswithzhz
I
Rajesh Karunakaran
  • Locked
  • Question
QR generated by FoxBarcodeQR doesn't contain the full content
Replies
5
Views
574
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top