serialno is null 判断为空
判断不为空:
select serialno,applyno,examcode,examname,hisordercode,hisordername,itemtype,xmsl,itemunit,addtype from Lis_AcceptItems
where (not serialno is null)serialno is null 判断为空
判断不为空:
select serialno,applyno,examcode,examname,hisordercode,hisordername,itemtype,xmsl,itemunit,addtype from Lis_AcceptItems
where (not serialno is null)