写一下机器的配置:装了个WINDOWS SERVER 2008 配置8核1.6G CPU 配置32GB内存
这个语句 select * from scrw a left join (select gckh,ddlx,hbbz, zzbz,hbdh as hbdh,LC00069999.f_DDGCLTYQHB(HBDH)GCLTYQ from LLDD where hbdh='')b on a.scrw_ddbh=b.hbdh where a.scrw_rwdh='SCRW200904070221'2000下没问题,2008就不行了,也会死锁
select * from scrw a
left join (select gckh,ddlx,hbbz, zzbz,hbdh as hbdh,LC00069999.f_DDGCLTYQHB(HBDH)GCLTYQ
from LLDD where hbdh='')b
on a.scrw_ddbh=b.hbdh
where a.scrw_rwdh='SCRW200904070221'2000下没问题,2008就不行了,也会死锁