小小问题，想请教高手？
Select * From Table With(UpdLock) 这句话是锁定整张表吗？？
在Select * From Table With(UpdLock) 后面能不能加where子句？？
望指教！
问题点数：20、回复次数：4Top
1 楼LouisXIV（夜游神）回复于 2006-07-03 00:01:29 得分 15
Use update locks instead of shared locks while reading a table, and hold locks until the end of the statement or transaction. UPDLOCK has the advantage of allowing you to read data (without blocking other readers) and update it later with the assurance that the data has not changed since you last read it.
这条语句可以用于锁定指定记录。
当然可以附加Where条件Top
2 楼zjdyzwx（十一月猪）回复于 2006-07-03 10:52:52 得分 5
当然可以Top
3 楼jetdw（空间商务）回复于 2006-07-03 11:07:10 得分 0
LouisXIV(夜游神)大哥回答问题好快啊
说的非常好，学习学习！Top
4 楼Tcer66（）回复于 2006-07-05 12:42:52 得分 0
很抱歉，忘了揭贴了Top
