Using Table-Valued Function in MS SQL

Code:

-- SET NOCOUNT ON 

CREATE FUNCTION DatesBetween2()
RETURNS @dates TABLE (
   DateValue date NOT NULL PRIMARY KEY CLUSTERED
) 
as
begin
DECLARE @startDate DATETIME = GETDATE();
DECLARE @endDate DATETIME = DATEADD(day, 9999, GETDATE());
BEGIN
   WHILE (@startDate <= @endDate) BEGIN
      INSERT INTO @dates VALUES (@startDate);
      SET @startDate = DATEADD(day, 1, @startDate);
   END;
   RETURN;
END;
END;

select * from dbo.DatesBetween2()