主页 / dba / 问题 / 51755
Accepted
user29534
Asked: 2013-10-19 05:03:19 +0800 CST

如何以更优雅的方式在 SQL Server Compact 中编写此查询？

  • 772

查询是：

 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'

在 SQL Server Compact 中运行不佳的原始查询（与上述查询相同）是：

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

1 个回答

  1. Best Answer

    T-SQL中没有多值CASE语句。但是，您可以像这样连接到一个常量值行源：

    SELECT *
  FROM dbo.Statuses AS S
  LEFT JOIN (VALUES(1,'Success','AStatus','Expected:1'),
                   (0,'Failure','AStatus','Received:0')
            ) AS SV(AStatus, Status, Reason, Message)
    ON S.AStatus = SV.AStatus;
    • 5

相关问题