進來幫下忙,SQL語句.

[Hideal]

我用:
x_RS.Open "Select Cloth_SM_ID2,Cloth_SM_ID3 from Cloth_GZ" 語句沒問題.

但我改成這樣:
x_RS.Open "Select Cloth_SM_ID2,iif(isnull(Cloth_SM_ID3),0,Cloth_SM_ID3) As xxx from Cloth_GZ "就出問題,報錯: "The isnull function requires 2 arguments"

為什么呢?isnull可以用到sql語句中的啊.

[cindytsai]

结果为零的时候，还可以处理吗？

[Hideal]

怎樣改?

[Hideal]

x_RS.Open "Select Cloth_SM_ID2,iif(isnull(Cloth_SM_ID3),60,30) As xxx from Cloth_GZ

x_RS.Open "Select Cloth_SM_ID2,iif(isnull(Cloth_SM_ID3),60,Cloth_SM_ID3) As xxx from Cloth_GZ
.
.
.
都是一樣會出錯.

[射天狼]

The isnull function requires 2 arguments
isnull需要两个参数,将你的SQL语句拿到查询分析器中执行一下!

[饮水需思源]

x_RS.Open "Select Cloth_SM_ID2,isnull(Cloth_SM_ID3,0) As xxx from Cloth_GZ "

[Hideal]

Leftie(左手,为人民币服务):

你的方法可以,但我這個語句為什么會出錯呢?我經常用 select A,IIF(isnull(b),0,b) from X 這樣的語句都可以.
我用這些語句連SQLSERVER會出錯..


真正原因在那呢?

[Hideal]

完了,我現在用這樣的語句又出錯.

Select Cloth_SM_Name2,iif(Cloth_SM_ID3='A','A1','A2') As xxx from Cloth_GZ

請再幫下忙吧.

[icedut]

iif 不是sqlserver函数

要换成case

[icedut]

Select Cloth_SM_Name2,case Cloth_SM_ID3 when 'A' then 'A1' else 'A2' end As xxx from Cloth_GZ

[icedut]

iif可以在access,vb中用
如果要在sqlserver语句中用,要替换成case

使用 CASE 处理条件数据
CASE 函数用于计算多个条件并为每个条件返回单个值。CASE 函数通常的用途是使用可读性更强的值替换代码或缩写。下面的查询使用 CASE 函数重命名书籍的分类，以使之更易理解。

USE pubs
SELECT
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END AS Category,
CONVERT(varchar(30), title) AS "Shortened Title",
price AS Price
FROM titles
WHERE price IS NOT NULL
ORDER BY 1