如何产生死锁?

因为项目测试需要,要测试死锁情况下的程序反映,,

可是应该如何制造这样情况呢,,
用的是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

两个过程同时执行就产生死锁,好好琢磨吧

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus