declare @MSISDN varchar(50)
set @MSISDN = ? begin
if (@MSISDN='')
set @MSISDN='%%'
else
set @MSISDN='%'+ @MSISDN +'%'
end SELECT ID,ROLE,MSISDN,COMM_ID,OPERATION_NAME,OCCUR_TIME,STATUS,ERR_MESSAGE from ADEADMIN.T_MONITOR_MOMT WHERE MSISDN like @MSISDN and OCCUR_TIME >= (?,'YYYY-MM-DD') and OCCUR_TIME >= (?,'YYYY-MM-DD')
set @MSISDN = ? begin
if (@MSISDN='')
set @MSISDN='%%'
else
set @MSISDN='%'+ @MSISDN +'%'
end SELECT ID,ROLE,MSISDN,COMM_ID,OPERATION_NAME,OCCUR_TIME,STATUS,ERR_MESSAGE from ADEADMIN.T_MONITOR_MOMT WHERE MSISDN like @MSISDN and OCCUR_TIME >= (?,'YYYY-MM-DD') and OCCUR_TIME >= (?,'YYYY-MM-DD')
MSISDN := ? begin
if (MSISDN='') then
MSISDN:='%%';
else
MSISDN:='%'+ MSISDN +'%';
end if;
endSELECT ID,ROLE,MSISDN,COMM_ID,OPERATION_NAME,OCCUR_TIME,STATUS,ERR_MESSAGE
from ADEADMIN.T_MONITOR_MOMT
WHERE MSISDN like MSISDN
and OCCUR_TIME >= (?,'YYYY-MM-DD') and OCCUR_TIME >= (?,'YYYY-MM-DD')
MSISDN := ? begin
if (MSISDN='') then
MSISDN:='%%';
else
MSISDN:='%'+ MSISDN +'%';
end if;
endSELECT ID,ROLE,MSISDN,COMM_ID,OPERATION_NAME,OCCUR_TIME,STATUS,ERR_MESSAGE
from ADEADMIN.T_MONITOR_MOMT
WHERE MSISDN like MSISDN
and OCCUR_TIME >= (?,'YYYY-MM-DD') and OCCUR_TIME >= (?,'YYYY-MM-DD');
前面少了个分号