代码如下:ALTER FUNCTION [dbo].[get_FullAge]( @birthday datetime, @currentDay datetime)RETURNS INTASBEGINDECLARE @age INTSET @age = DATEDIFF(YEAR, @birthday, @currentDay)IF DATEDIFF(DAY, DATEADD(YEAR, @age, @birthday), @currentDay) <= 0 SET @age = @age – 1IF DATEPART(MONTH, @birthday) = 2 AND DATEPART(D
