关于锁的问题,帮帮我!谢谢!

[lizhenlz]

有很多对别的语句,进行操作,在对这些语语句操作时,要在这些语句前与后加上对一个表的操作,请问怎样,锁表和解锁!
--锁表
set transaction ISOLATION LEVEL serializable
begin Transaction trans1
select * from tBase_Air_Day with (TABLOCKX)
delete from #_temp_Emms
where (#_temp_Emms.jczdm+CAST(#_temp_Emms.cdbh AS nvarchar(4))
+CAST(#_temp_Emms.[year] AS nvarchar(4))+ '/'+ CAST(#_temp_Emms.[month]
AS nvarchar(2))+'/'
+ CAST(#_temp_Emms.[day] AS nvarchar(2))) in
(select strAreaID+CAST(nEmmsID AS nvarchar(4))
+CAST(year(dMoni) AS nvarchar(4))+'/'+ CAST(Month(dMoni) AS
nvarchar(2))+'/'
+ CAST(Day(dMoni) AS nvarchar(2))
from vBase_Air_Day_Emms)
commit Transaction trans1
--解锁,这样可以吗?
对锁理解可能不对,请大虾,指点!

[WT滔滔江水]

几句闲话：最近在事务上吃尽苦头，得出一个简单的道理，事务锁锁的范围在保证数据正确的情况下一定要越小越好。否则由于系统死锁给整个系统造成的损失是十分惨通的。

[nielisheng]

锁可以加在每一条t-sql语句上，事务和锁不完全同，用sql server 默认的锁就足够了.