karthiks · November 6, 2021 14:32
diff --git a/table-valued-udf.sql b/table-valued-udf.sql
 CREATE OR ALTER FUNCTION dbo.AgeStatus
 (
  @AGE INT
 )
 RETURNS CHAR(10) 
 AS
 BEGIN
  DECLARE @status CHAR(5);
  IF @AGE < 18
    SET @category = 'MINOR';
  ELSE
    SET @category = 'MAJOR';
  RETURN @status
 END

 /*
 Now, consider a query that invokes this UDF:
 SELECT NAME, dbo.AgeStatus(AGE) FROM CUSTOMER;
 */
	CREATE OR ALTER FUNCTION dbo.AgeStatus
	(
	@AGE INT
	)
	RETURNS CHAR(10)
	AS
	BEGIN
	DECLARE @status CHAR(5);
	IF @AGE < 18
	SET @category = 'MINOR';
	ELSE
	SET @category = 'MAJOR';
	RETURN @status
	END

	/*
	Now, consider a query that invokes this UDF:
	SELECT NAME, dbo.AgeStatus(AGE) FROM CUSTOMER;
	*/