结果基于if条件 [英] results based on if condition

问题描述

我需要根据使用case语句传递的参数显示结果 或者条件我该怎么办

I need to display results based on the parameter passed using case statement  or if condition how can i do it

  DECLARE @FullName VARCHAR（100）

 DECLARE @FullName VARCHAR(100)

SET @ FullName ='Lisa S Guo'   或  SET @ FullName ='Raul'

SET @FullName='Lisa S Guo'   or SET @FullName='Raul'

SELECT 



Pc.ContactID，FirstName，MiddleName，LastName，

ISNULL（FirstName +''+ MiddleName +' '+ LastName，FirstName +''+ LastName）  AS FullName，

TotalDue

FROM Person.Contact Pc

INNER JOIN Sales.SalesOrderHeader Ss

ON Pc.ContactID = Ss.ContactID



） AS A WHERE @ FullName = FullName

SELECT 

Pc.ContactID,FirstName,MiddleName,LastName,
ISNULL(FirstName + ' ' + MiddleName + ' ' + LastName,FirstName + ' ' + LastName)  AS FullName,
TotalDue
FROM Person.Contact Pc
INNER JOIN Sales.SalesOrderHeader Ss
ON Pc.ContactID=Ss.ContactID

) AS A WHERE @FullName=FullName

如果传递了其他值，它应该根据 来获取该值。案例陈述或条件 

if some other value is passed it should pick up that value based on the  case statement or if condition 

Smash126

推荐答案

目前尚不清楚，您想申请的条件是什么？

It is not clear, what is the condition you want to apply?

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