34,591
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM( Len(ISNULL(NULLIF(t1.name,t2.name),''))
+ Len(ISNULL(NULLIF(t1.sex,t2.sex),''))
+ Len(ISNULL(NULLIF(t1.address,t2.address),''))
+ Len(ISNULL(NULLIF(t1.age,t2.age),''))
)
FROM table1 t1
LEFT JOIN table2 t2
ON t2.barcode = b1.barcode
WHERE t1.class = @class
select sum((CASE WHEN A.NAME<>B.name THEN len(A.name)ELSE 0 END)+ len(A.sex)+ len(A.address)+ len(A.age) )
from table1 A
LEFT JOIN table2 B ON A.barcode=B.barcode
where A.class=@class