因为项目测试需要,要测试死锁情况下的程序反映,,
可是应该如何制造这样情况呢,,
用的是sybase
---------------------------------------------------------------
create procedure aa
as
declare @val1 char(10)
declare @val2 char(10)
begin
update tab1 set column1 =@val1
update tab2 set column1 =@val2
end
create procedure bb
as
declare @val1 char(10)
declare @val2 char(10)
begin
update tab2 set column1 =@val2
update tab1 set column1 =@val1
end
两个过程同时执行就产生死锁,好好琢磨吧