udfdemo1.sql

T-SQL示例大全

/* 文件名称: UDFDemo1.sql */
USE 北风贸易
GO

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'dbo.udf_Age') and xtype = N'FN')
    DROP FUNCTION dbo.udf_Age

GO

-- 建立一个用来计算出年龄的用户自定义函数
CREATE FUNCTION dbo.udf_Age
(@birthday datetime,@currentdate datetime)
RETURNS tinyint
AS
BEGIN
     RETURN DATEDIFF(yy,@birthday,@currentdate)
END

GO