sql - SQL Server Compact 是否支持多个返回案例参数

Question

我知道以下是合法的 SQL 查询，但为什么不能在 SQL Server Compact 中解释它？ (我正在使用 SQL Server Compact View )

Select  
   Case AStatus  
      When 1 then 'Success', 'AStatus', 'Expected:1'  
      When 0 then 'Faliure', 'AStatus', 'Recived: 0'    
   end
From Statuses  
Where LocalPath= 'c:\Status  

我得到类似的东西:

Query 1 : There was an error parsing the query [Token line number=3, Token line offset=22, Token in Error=,]

当编写类似下面的内容时，它会起作用:

Select  
   Case AStatus  
      When 1 then 'Success'
      When 0 then 'Faliure'  
   end
From Statuses  
Where LocalPath= 'c:\Status  

Answer 1

我认为这是从 case 中获取三列的唯一有效方法:

Select  
    Case AStatus  
        When 1 then 'Success'
        When 0 then 'Faliure'
    END,
    Case AStatus  
        When 1 then 'AStatus'
        When 0 then 'AStatus'
    END,
    Case AStatus  
        When 1 then 'Expected:1'  
        When 0 then 'Recived: 0'  
    END
From Statuses  
Where LocalPath= 'c:\Status'

编辑:其他方式。短不了多少，但看起来更灵活:

Select  
    Astatus,
    x.*
From Statuses s
CROSS APPLY (
    select 'Success' as c1,'AStatus' as c2,'Expected:1' as c3 where AStatus=1 union all 
    select 'Failure' ,'AStatus','Recived:0' where AStatus=0
) x
Where LocalPath= 'c:\Status'

因为让我想出了这个，你得到 +1，我已经知道我会在哪里使用它:)。