一个SQL题,我底子弱,收藏下

写一个存储过程，判断8个参数是否存在两两相等的参数

解决办法:

union   --会合并相同的值。。
union   all   --不合并,
所以指定union求记录数就行了 

具体源码:

 

CREATE     PROCEDURE    sp_JudgeValid 
                                     @iPara1       INT , 
                                     @iPara2       INT , 
                                     @iPara3       INT , 
                                     @iPara4       INT , 
                                     @iPara5       INT , 
                                     @iPara6       INT , 
                                     @iPara7       INT , 
                                     @iPara8       INT  
AS  
BEGIN  
if  ( select   count ( 1 )
from  
( select   @iPara1   as  col  union    select   @iPara2   union    select   @iPara3   union    select   @iPara4
union    select   @iPara5   union    select   @iPara6   union    select   @iPara7   union    select   @iPara8 )T) < 8
         BEGIN  
                 RETURN     0  
         END  
         ELSE  
               RETURN     1  
         END  
END

 

原文地址:http://topic.youkuaiyun.com/u/20071125/01/28d9395e-3fc3-4e01-a39b-6460b1e109e5.html