文档介绍:一、药品用法录入错误修改语句:
1、select * from zy_ypyf
2、select yzmc,kzsj,gytj from emr_yzb where zyh in(select zyh from zy_brry where zyhm='0099193A') and gytj=7 and yysx=2 for update(1长,2临)
3、select yzmc,ypyf from zy_bqyz where zyh in(select zyh from zy_brry where zyhm='0099193A') and ypyf=7 and lsyz=1 for update
4、select * from emr_yzdy where zyh in(select zyh from zy_brry where zyhm='0099193A') and yzqx=2 for update
二、护士医嘱复核数据不会消失修改语句:
select * from zy_brry where zyhm='00200816' for update
:select yzmc,sybz,lsbz from zy_bqyz where zyh in(select zyh from zy_brry where zyhm='00200801') and lsyz=1 and lsbz=0 for update
选择多个科室:select * from gy_qxkz where ygdm=180 and ywlb like'%病区%' and mrbz=1 for update
:SELECT * FROM Ms_Brda WHERE BRXM LIKE'%病人姓名%'
select * from ms_ghks where ksdm in(05,85)
select * from ms_ghmx where brid=104233 for update
select * from ms_cf01 where fphm=3394787
select * from ys_mz_jzls where jzxh=46106
select * from ms_brda WHERE BRXM LIKE'%病人姓名%'
打印后医嘱修改语句:select yzmc,ds,dsdw from emr_yzb where zyh in(select zyh from zy_brry where zyhm='00200955') and yysx=2 for update
select * from emr_yzdy where zyh=1502 for upd