sql-server-2005 - 检查存储过程中的条件(sql server 2005)

Question

我有一个 SP，我需要在其中检查 if 条件

ALTER   PROCEDURE [dbo].[spCheck]  
 @strEmpname  VARCHAR(50),  
 @intReturn  INT OUTPUT,
 @intWorkdID  INT,
 @intEmpID INT  
AS  

BEGIN  
IF(@intWorkdID is not null and @intWorkdID != '')
    BEGIN 
      IF EXISTS ( SELECT *   
          FROM Employee   
         WHERE [Empname] = @strEmpname   
         AND WorkID = @intWorkdID 
           )  
       SELECT @intReturn = '1'  
    END 
ELSE    
IF(@intEmpID is not null and @intEmpID != '')
   BEGIN
     IF EXISTS ( SELECT * 
          FROM Employee   
         WHERE [Empname] = @strEmpname    
         AND PeopleID = @intEmpID 
           )  
       SELECT @intReturn = '1'   
    END
 ELSE IF(@intEmpID is not null and @intEmpID != '') 
 and(@intWorkdID is not null and @intWorkdID != '')
  BEGIN  
   SELECT @intReturn = '0'  
  END  

END  

这里根据WorkID,EmpID
应执行 1 个条件和 2 个条件

如果两个条件都失败，我需要执行第三个条件

谁能告诉它的语法

谢谢

王子

Answer 1

最好的方法是你可以使用

尝试如下操作:

SELECT @intReturn = 
     CASE
          WHEN @intWorkdID IS NULL THEN 1
          WHEN @intWorkdID<>'' THEN 1
          WHEN @intEmpID IS NULL THEN 1
          WHEN @intEmpID <>'' THEN 1
          ELSE 0
     END

Case... When

为此