27,581
社区成员
发帖
与我相关
我的任务
分享在sql语句中怎么样使用iif函数？
在sql语句中怎么样使用iif函数？
select b.ID,a.src_terminal_id,convert(varchar(255),b.msg_content) as content,
a.House_Number,a.Flag,b.ih_timestamp from SHQ_note as a INNER JOIN cm as b
on a.upid=b.id where DATEDIFF(Day,b.ih_timestamp,getdate())<=10 AND IIF(LEFT(a.src_terminal_id,2)='86',SUBSTRING(a.src_terminal_id,3,3),LEFT(a.src_terminal_id,3))>=100
order by b.id desc
说有错误，是不是iif函数有问题？
select b.ID,a.src_terminal_id,convert(varchar(255),b.msg_content) as content,
a.House_Number,a.Flag,b.ih_timestamp from SHQ_note as a INNER JOIN cm as b
on a.upid=b.id where DATEDIFF(Day,b.ih_timestamp,getdate())<=10 AND IIF(LEFT(a.src_terminal_id,2)='86',SUBSTRING(a.src_terminal_id,3,3),LEFT(a.src_terminal_id,3))>=100
order by b.id desc
说有错误，是不是iif函数有问题？
...全文
请发表友善的回复…
发表回复
tinghuyang 2004-10-18
- 打赏
- 举报
up
hhgb 2004-10-17
- 打赏
- 举报
使用
case when 条件 then 处理 else 处理 end
case when 条件 then 处理 else 处理 end
Andy__Huang 2004-10-17
- 打赏
- 举报
select b.ID,a.src_terminal_id,convert(varchar(255),b.msg_content) as content,
a.House_Number,a.Flag,b.ih_timestamp
from SHQ_note as a
INNER JOIN cm as b
on a.upid=b.id
where DATEDIFF(Day,b.ih_timestamp,getdate())<=10
AND (case when LEFT(a.src_terminal_id,2)='86' then SUBSTRING(a.src_terminal_id,3,3) else LEFT(a.src_terminal_id,3) end)>=100
order by b.id desc
a.House_Number,a.Flag,b.ih_timestamp
from SHQ_note as a
INNER JOIN cm as b
on a.upid=b.id
where DATEDIFF(Day,b.ih_timestamp,getdate())<=10
AND (case when LEFT(a.src_terminal_id,2)='86' then SUBSTRING(a.src_terminal_id,3,3) else LEFT(a.src_terminal_id,3) end)>=100
order by b.id desc
Andy__Huang 2004-10-17
- 打赏
- 举报
sql server2000里沒有iif()函數﹐它用case when ....then ....end代替
