( begindate in Date,enddate in date,ret out int ) as begin aa(begindate,enddate); lock table test1 in exclusive mode nowait; insert into test1 select a.hospitalid,count(a.hospitalid) from test a,DB_Optionvalue B,DB_DateValue c ,CareInfo D where B.OPTIONVALUEHEALTHCODE=C.DATEVALUEHEALTHCODE AND B.OPTIONVALUEHEALTHCODE=D.CAREINFOHEALTHCODE AND A.HOSPITALID=B.OPTIONVALUEHOSPITAL AND B.OPTIONELEMENTVALUE=399 AND B.OVALUE=217 GROUP BY A.Hospitalid; commit; rollback; end;上面的这段写法可以对TEST1表里做锁处理么,处理正确么
begindate in Date,enddate in date,ret out int
)
as
begin
aa(begindate,enddate);
lock table test1 in exclusive mode nowait;
insert into test1
select a.hospitalid,count(a.hospitalid) from
test a,DB_Optionvalue B,DB_DateValue c
,CareInfo D
where B.OPTIONVALUEHEALTHCODE=C.DATEVALUEHEALTHCODE
AND B.OPTIONVALUEHEALTHCODE=D.CAREINFOHEALTHCODE
AND A.HOSPITALID=B.OPTIONVALUEHOSPITAL
AND B.OPTIONELEMENTVALUE=399
AND B.OVALUE=217
GROUP BY A.Hospitalid;
commit;
rollback;
end;上面的这段写法可以对TEST1表里做锁处理么,处理正确么