有没有人帮忙看下这句sql语句有什么问题?谢谢了,页面提示错误:
com.microsoft.sqlserver.jdbc.SQLServerException: ')' 附近有语法错误。SELECT
M.RECEIPT_MAIL_ADDR,
M.NEXT_SEND_TIME,
M.LAST_SEND_TIME,
M.SEND_FLAG,
DBO.GET_DICT_DATA_NAME ('SEND_FLAG', M.SEND_FLAG ) AS SEND_FLAG_DISPLAY,
M.SKIP_MINUTES,
M.SEND_COUNT,
M.SEND_SUCCESS_COUNT,
M.LAST_FAIL_REASON,
MS.MAIL_CONTENT,
M.RECEIVE_CONTENT,
<!--
A.CONTACT_NAME AS CONTACTOR_NAME,
A.DEPT_NAME AS COM_NAME ,
-->
A.CONTACT_NAME AS GOV_PEOPLE_NAME,
A.DEPT_NAME AS GOV_DEPT_NAME
FROM V_CELL_PHONE_PERSONS A,ms_task_person_w M,MS_TASK_W MS
WHERE A.CELL_NUM(+) = M.RECEIPT_MAIL_ADDR AND M.MS_TASK_ID=MS.MS_TASK_ID
AND M.MS_TASK_ID= #criteria.msTaskId#
<isNotEmpty property="criteria.sendFlag" prepend="AND">
M.SEND_FLAG=#criteria.sendFlag#
</isNotEmpty>
order by GOV_PEOPLE_NAME asc
SQLsqlserver2008oraclesqlserver
com.microsoft.sqlserver.jdbc.SQLServerException: ')' 附近有语法错误。SELECT
M.RECEIPT_MAIL_ADDR,
M.NEXT_SEND_TIME,
M.LAST_SEND_TIME,
M.SEND_FLAG,
DBO.GET_DICT_DATA_NAME ('SEND_FLAG', M.SEND_FLAG ) AS SEND_FLAG_DISPLAY,
M.SKIP_MINUTES,
M.SEND_COUNT,
M.SEND_SUCCESS_COUNT,
M.LAST_FAIL_REASON,
MS.MAIL_CONTENT,
M.RECEIVE_CONTENT,
<!--
A.CONTACT_NAME AS CONTACTOR_NAME,
A.DEPT_NAME AS COM_NAME ,
-->
A.CONTACT_NAME AS GOV_PEOPLE_NAME,
A.DEPT_NAME AS GOV_DEPT_NAME
FROM V_CELL_PHONE_PERSONS A,ms_task_person_w M,MS_TASK_W MS
WHERE A.CELL_NUM(+) = M.RECEIPT_MAIL_ADDR AND M.MS_TASK_ID=MS.MS_TASK_ID
AND M.MS_TASK_ID= #criteria.msTaskId#
<isNotEmpty property="criteria.sendFlag" prepend="AND">
M.SEND_FLAG=#criteria.sendFlag#
</isNotEmpty>
order by GOV_PEOPLE_NAME asc
SQLsqlserver2008oraclesqlserver
<!--
A.CONTACT_NAME AS CONTACTOR_NAME,
A.DEPT_NAME AS COM_NAME ,
--> AND M.MS_TASK_ID= #criteria.msTaskId#
<isNotEmpty property="criteria.sendFlag" prepend="AND">
M.SEND_FLAG=#criteria.sendFlag#
</isNotEmpty>
这些都是不符合语法的呀