create function LongYear(@a int) returns int
as
begin
declare @result int
if (@a%400=0) or (@a%4=0 and @a%100<>0) select @result= 1 else select @result=0
return @result
end
go
select dbo.LongYear(1996)
as
begin
declare @result int
if (@a%400=0) or (@a%4=0 and @a%100<>0) select @result= 1 else select @result=0
return @result
end
go
select dbo.LongYear(1996)
set @a=1992
if (@a%400=0) or (@a%4=0 and @a%100<>0)
select '是闰年'
else
select '不是闰年'