SQL SELECT If (a="") 然后更改 b 值

SQL SELECT If (a="") Then change b value

提问by Tyler Mortensen

This seems like a simple question, but I haven't been able to find an answer. I am basically trying to do this:

这似乎是一个简单的问题，但我一直无法找到答案。我基本上是在尝试这样做：

SELECT * FROM table1
IF(columnA > 0) BEGIN
columnB = 'Greater than 0'
END

I don't want the value to change in the table, I just want it to change in the result. ANy suggestions?

我不希望表中的值发生变化，我只希望它在结果中发生变化。有什么建议？

回答by Kevin Suchlicki

SELECT  ColumnA
        , case when ColumnA > 0 then 'Greater than 0' else ColumnB END AS ColumnB 
FROM    table1;

回答by Ted Hopp

This should work:

这应该有效：

SELECT columnA, IIF(columnA > 0, 'Greater than 0', columnB)
  FROM table1;