这是我们软件架构设计课程的一个大作业,给的是英文版的The Golden Age of Software Architecture-A Comprehensive Survey(CMU-ISRI-06-101),只是中文版The Golden Age of Software Architecture-A Comprehensive Survey(CMU-ISRI-06-101),希望对大家有帮助!!!!
代码如下: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 DAT