这样简单的存贮过程也死锁，没天理
procedure pxxx
@syssign varchar(2)
as
begin tran
update table1 set pa1=pa1+1 where xx=@syssign
select pa=pa1 from table1 where xx=@syssign
commit tran
过年前没死锁，年后开始了。请问如何解决
[解决办法]
select pa=pa1 from table1 where xx=@syssign
-----------------------------------------
pa是@pa吧？
[解决办法]
--try
create procedure pxxx
@syssign varchar(2)
as
begin tran
update table1 set pa1=pa1+1 where xx=@syssign
commit tran
select pa=pa1 from table1 where xx=@syssign
[解决办法]
测试了没问题
不知道楼主是在并发度多大的环境出现死锁的
[解决办法]
--try:
procedure pxxx
@syssign varchar(2)
as
begin tran
update table1 set pa1=pa1+1 where xx=@syssign
select pa=pa1 from table1 with (XLOCK) where xx=@syssign
commit tran
