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