MSSQL求100999的水仙花数

--author：【DBA】小七
--datatime: 2010-1-20 16:52:00
--title:100-999的水仙花数 

--水仙花数：如果三位数的个位的三次方加十位的三次方加上百位的三次方之和为其本身，那么这个数就为水仙花数
declare @a int
set @a=100;
while @a<=999 
BEGIN

if power(substring(cast(@a as char(3)),1,1),3)+
power(substring(cast(@a as char(3)),2,1),3)+
power(substring(cast(@a as char(3)),3,1),3)=@a 
begin 
print @a
end
set @a=@a+1
end