update zz1
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' and cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in(select jtdh from zx where id = '17')
when cmdm = 'LTC' and cmdm = 'LXY' and newdh in(select jtdh from zx where id = '18' ) then 13
else cmdm end;各位大侠 这样子有错喃,应该怎样写这样的sql语句喃???在线等···
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' and cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in(select jtdh from zx where id = '17')
when cmdm = 'LTC' and cmdm = 'LXY' and newdh in(select jtdh from zx where id = '18' ) then 13
else cmdm end;各位大侠 这样子有错喃,应该怎样写这样的sql语句喃???在线等···
解决方案 »
- MSSQL的表空间
- 求助SQL的CLR编程,无法引用System.Web.dll
- Excel表格导入到SQL数据库为什么会出现NULL值呢?
- 怎么去掉数值中的字符
- sql 链接不上 帮忙看下 ⊙﹏⊙b汗
- ODBC里的密码问题
- 怎么判断临时表是否存在?
- 存储过程导致timeout问题!
- 请问我在PB6。5中怎样用专用接口连接SQL SERVER7?(请详细点,在线wait)
- 请教:一个不知道什么版本的access数据库文件senttq.mdb能用access打开,但是通过odbc数据源连接好象连不上?也不知道如何测试!我是在程序中连接这个ODBC数据源的时候出错的!
- 一张表中存在多条记录的两个字段值交叉相等,查询时如何过滤,只取一条记录
- 各位宇宙超级无敌霹雳mssql大神们进来啊~~求助啊
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' and cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in(select jtdh from zx where id = '17') then 12
when cmdm = 'LTC' and cmdm = 'LXY' and newdh in (select jtdh from zx where id = '18' ) then 13
else cmdm end;
少了
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' and cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in (select jtdh from zx where id = '17') then 12
when cmdm = 'LTC' and cmdm = 'LXY' and newdh in(select jtdh from zx where id = '18' ) then 13
else cmdm end;
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' OR cmdm = 'JSE' then 2
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' and cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in(select jtdh from zx where id = '17') then 12
when cmdm = 'LTC' and cmdm = 'LXY' and newdh in (select jtdh from zx where id = '18' ) then 13
else cmdm end;
set zxbh = case when cmdm = 'JWQ' then 1
when cmdm = 'JSY' or cmdm = 'JSE' then 2
when cmdm = 'HJC' then 3
when cmdm = 'KJY' then 11
when cmdm = 'LTC' and newdh in(select jtdh from zx where id = '17') then 12
when (cmdm = 'LTC' or cmdm = 'LXY') and newdh in(select jtdh from zx where id = '18' ) then 13
else cmdm end;
多谢---htl258-----
多谢其他人的回复,谢谢~~~