/*
Describle:奇偶年，月份数字转字母
Create By:
Date:
*/
CREATE FUNCTION [dbo].[fn_Y_monthchar]
(
@y NVARCHAR(10),
@m NVARCHAR(10)
)
RETURNS VARCHAR(10)
AS
BEGIN
declare @a1 table (i int identity(1,1) not null,b nvarchar(1),c nvarchar(1))
declare @code nvarchar(10)
insert @a1 (b,c) values (‘E’,’1′),(‘F’,’2′),(‘H’,’3′),(‘J’,’4′),(‘K’,’5′),(‘L’,’6′),(‘N’,’7′),(‘P’,’8′),(‘U’,’9′),(‘X’,’T’),(‘Y’,’V’),(‘Z’,’C’)
if @y%2=0
begin
select @code=c from @a1 where i=@m
end
else
begin
select @code=b from @a1 where i=@m
end
RETURN @code
END
