Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL record locking and transactions
Message
 
To
04/03/2004 13:32:04
Fabio Lunardon
Lunacom
Marostica, Italy
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL record locking and transactions
Miscellaneous
Thread ID:
00874330
Message ID:
00883205
Views:
14
So are you saying that

SELECT * FROM dbo.Shippers (UPDLOCK,ROWLOCK) WHERE ShipperID=1

Will utilize the Rowlock only if ShipperID is indexed?
http://www.danasoft.com/sig/JMASig.jpg
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform