示例如下:
事务A:
begin tran
select * from t with(tablockx)
waitfor delay '00:00:05'
commit tran
事务B:
sp_lock
sp_lock的显示结果(部分):
spid dbid ObjId IndId Type Resource Mode Status
------ ------ ----------- ------ ---- ---------------- -------- ------
...
56 1 273436048 0 TAB X GRANT
58 1 85575343 0 TAB IS GRANT
59 16 0 0 DB S GRANT
...
--事例
Create Function F_GetID()
Returns Varchar(10)
As
Begin
Declare @S Varchar(10)
Select @S= 'LZ'+Right(100000000+IsNull(Right(Max(ID),8),0)+1,8) From t1 WITH(XLOCK,PAGLOCK)
Return @S
End