CREATE FUNCTION [dbo].[GetMonthName]
(
-- Add the parameters for the function here
@month int
)
RETURNS varchar(10)
AS
BEGIN
DECLARE @month_name varchar(10)
IF @month = 1
BEGIN
SET @month_name = 'January';
END
ELSE IF @month = 2
BEGIN
SET @month_name = 'February';
END
ELSE IF @month = 3
BEGIN
SET @month_name = 'March';
END
ELSE IF @month = 4
BEGIN
SET @month_name = 'April';
END
ELSE IF @month = 5
BEGIN
SET @month_name = 'May';
END
ELSE IF @month = 6
BEGIN
SET @month_name = 'June';
END
ELSE IF @month = 7
BEGIN
SET @month_name = 'July';
END
ELSE IF @month = 8
BEGIN
SET @month_name = 'August';
END
ELSE IF @month = 9
BEGIN
SET @month_name = 'September';
END
ELSE IF @month = 10
BEGIN
SET @month_name = 'October';
END
ELSE IF @month = 11
BEGIN
SET @month_name = 'November';
END
ELSE IF @month = 12
BEGIN
SET @month_name = 'December';
END
ELSE
BEGIN
SET @month_name = 'Invalid month number!';
END
RETURN @month_name;
END
/*SELECT dbo.GetMonthName(1) as [month]
SELECT dbo.GetMonthName(month(getdate())) as [month]*/
(
-- Add the parameters for the function here
@month int
)
RETURNS varchar(10)
AS
BEGIN
DECLARE @month_name varchar(10)
IF @month = 1
BEGIN
SET @month_name = 'January';
END
ELSE IF @month = 2
BEGIN
SET @month_name = 'February';
END
ELSE IF @month = 3
BEGIN
SET @month_name = 'March';
END
ELSE IF @month = 4
BEGIN
SET @month_name = 'April';
END
ELSE IF @month = 5
BEGIN
SET @month_name = 'May';
END
ELSE IF @month = 6
BEGIN
SET @month_name = 'June';
END
ELSE IF @month = 7
BEGIN
SET @month_name = 'July';
END
ELSE IF @month = 8
BEGIN
SET @month_name = 'August';
END
ELSE IF @month = 9
BEGIN
SET @month_name = 'September';
END
ELSE IF @month = 10
BEGIN
SET @month_name = 'October';
END
ELSE IF @month = 11
BEGIN
SET @month_name = 'November';
END
ELSE IF @month = 12
BEGIN
SET @month_name = 'December';
END
ELSE
BEGIN
SET @month_name = 'Invalid month number!';
END
RETURN @month_name;
END
/*SELECT dbo.GetMonthName(1) as [month]
SELECT dbo.GetMonthName(month(getdate())) as [month]*/
No comments:
Post a Comment