用if条件的SQL查询？ [英] sql query with if condition?

问题描述

 ect O.OrderID，D.OrderDetailID，ProductName，
   -   当R.OrderDetailID = 65然后'0' 
   -    else'1时' 
   -    end  
 
  IF （D.OrderDetailID！= R.OrderDetailID）然后 '  1' 
 其他 '  0' 
  end  
   -   返回='0' 
 来自 dbo.vOrderDetails D  Join  tblOrders O  On  O.OrderID = D.OrderID 
 加入 t blCustomerLogins L  On  O.CustomerID = L.CustomerID 
  join  tblOrderReturns R  on  R.OrderDetailID = D.OrderDetailID 
 其中​​ O.OrderID =  65  和 L.SessionID = '  8004837C7D62qdSV8 ' 

如果条件不正确格式

解决方案

您可以尝试使用 CASE 。类似于：

 选择 O.OrderID，D.OrderDetailID，ProductName，
  case  
   D.OrderDetailID！= R.OrderDetailID 然后 '  1' 
  else  '  0' 
 结束  as  ColName 
 来自 dbo.vOrderDetails D 
  Join  tblOrders O  On  O.OrderID = D.OrderID 
  Join  tblCustomerLogins L  On  O.CustomerID = L.CustomerID 
  join  tblOrderReturns R 在 RO rderDetailID = D.OrderDetailID 
 其中 O.OrderID =  65  
 和 L.SessionID = '  8004837C7D62qdSV8' 

有关详细信息，请参阅 CASE（Transact-SQL） [ ^ ]

可以使用Case语句完成。

[在这里查看]

使用 Case 声明而不是。请查看以下链接以获取更多信息。



http://www.techonthenet.com/sql_server/functions/case.php

ect O.OrderID,D.OrderDetailID,ProductName,
--case when R.OrderDetailID   = 65 then '0'
--else '1'
--end

IF (D.OrderDetailID != R.OrderDetailID) Then '1'
Else '0'
end
--Returned='0'
From dbo.vOrderDetails D Join tblOrders O On O.OrderID = D.OrderID
Join tblCustomerLogins L On O.CustomerID = L.CustomerID
join tblOrderReturns R on R.OrderDetailID = D.OrderDetailID
Where O.OrderID = 65 And L.SessionID ='8004837C7D62qdSV8'

If condition is not correct format

解决方案

You can use the CASE as you have tried. Sommthing like:

select O.OrderID,D.OrderDetailID,ProductName,
case 
   when D.OrderDetailID != R.OrderDetailID then '1'
   else '0'
end as ColName
From dbo.vOrderDetails D 
     Join tblOrders O         On O.OrderID = D.OrderID
     Join tblCustomerLogins L On O.CustomerID = L.CustomerID
     join tblOrderReturns R   On R.OrderDetailID = D.OrderDetailID
Where O.OrderID = 65 
And L.SessionID ='8004837C7D62qdSV8'

For details see CASE (Transact-SQL)[^]

It can be done using Case statement.
[Check here]

Use Case statement instead. Have a look at below link for more information.

http://www.techonthenet.com/sql_server/functions/case.php

这篇关于用if条件的SQL查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！