SELECT A.USER_CD,A.USER_NAME,CASE A.SEX_DIS WHEN '1' THEN '男' else '女' end as SEX_DIS,(A.EMAIL_ADDRESS1 + ' 、'++ A.EMAIL_ADDRESS2 )as Email_Address,
((case A.MOBILE_CMP when '0' then 'AU' end as mobile_cmp) + ' ' + A.MOBILE_NUMBER) as Mobile,A.OPEN_FLG FROM
M_USER A,M_DEPARTMENT B WHERE (user_cd IS NULL OR USER_CD like '%'+ '0020700' + '%') AND (user_name IS NULL OR USER_NAME LIKE '%' + '高華' +'%' )
and (department_name is null or B.DEPARTMENT_NAME like '%' + '002000' + '%') AND A.DEPARTMENT_CD = B.DEPARTMENT_CD
ORDER BY USER_CD
运行的时候会抱 Incorrect syntax near the keyword 'as'.到底是什么原因啊?
((case A.MOBILE_CMP when '0' then 'AU' end as mobile_cmp) + ' ' + A.MOBILE_NUMBER) as Mobile,A.OPEN_FLG FROM
M_USER A,M_DEPARTMENT B WHERE (user_cd IS NULL OR USER_CD like '%'+ '0020700' + '%') AND (user_name IS NULL OR USER_NAME LIKE '%' + '高華' +'%' )
and (department_name is null or B.DEPARTMENT_NAME like '%' + '002000' + '%') AND A.DEPARTMENT_CD = B.DEPARTMENT_CD
ORDER BY USER_CD
运行的时候会抱 Incorrect syntax near the keyword 'as'.到底是什么原因啊?
解决方案 »
- ASP.NET(C#)的File控件问题 纠结,不解
- ie8模式下jquery调用asp.net web service的问题
- 如何获取客户端的IP以及使用代理时代理服务器的IP?
- 哪位大虾能给我发点asp.net c#的源码阿!
- 再急问个水晶报表设计的问题啊 在线等啊
- Could not load file
- 为什么自动重定向到login.aspx呢?
- vs2005做网站时 ,点击浏览出现C:\PRO~\FireFox.exe
- c# 反序列化中国天气json失败,提示反序列化对象 属于类型 Weatherinfo 时出现错误。所需的命名空间“”中的结尾元素“weatherinfo”
- repeater控件的问题
- 在asp.net里想用可编辑下拉框
- 这种刷新怎么处理
(case A.MOBILE_CMP when '0' then 'AU' end + ' ' + A.MOBILE_NUMBER) as Mobile
SELECT A.USER_CD,A.USER_NAME,CASE A.SEX_DIS WHEN '1' THEN '男' else '女' end as SEX_DIS,(A.EMAIL_ADDRESS1 + ' 、'++ A.EMAIL_ADDRESS2 )as Email_Address,
case A.MOBILE_CMP when '0' then 'AU'+' '+A.MOBILE_NUMBER else A.MOBILE_NUMBER end as mobile_cmp,A.OPEN_FLG FROM
M_USER A,M_DEPARTMENT B WHERE (user_cd IS NULL OR USER_CD like '%'+ '0020700' + '%') AND (user_name IS NULL OR USER_NAME LIKE '%' + '高華' +'%' )
and (department_name is null or B.DEPARTMENT_NAME like '%' + '002000' + '%') AND A.DEPARTMENT_CD = B.DEPARTMENT_CD
ORDER BY USER_CD