title: Is it possible to have a function without a parameter in t-sql?
body: <p>I am being forced to put a @noparameter varchar(1)=null in this function?
  How do I create a function to return a table which has no parameters!</p>
  
  <pre>
  
  ALTER FUNCTION [dbo].[DropDownIndividuals](@noparameter varchar(1)=null)
  RETURNS
      @IndividualsList TABLE(
            Case_Number VARCHAR(11)
           ,LastName    VARCHAR(100)
           ,FirstName   VARCHAR(100)
           ,Midlename   VARCHAR(100)
           ,FullName    VARCHAR(100) 
          )
  AS  
  BEGIN
         INSERT INTO @IndividualsList
         SELECT DISTINCT
         cast(Case_Number as varchar(10))as Case_Number
        ,[Lastname]
        ,[Firstname]
        ,[Middlename]
        ,rtrim([Lastname]+ ' '+ [Firstname]) as FullName
        FROM [MHMODSSQL1P].[ODS].[dbo].[Contact]
        WHERE [LastName] is not null and [FirstName] is not null
        UNION ALL SELECT null,null,null,null,null
        ORDER BY [LastName]
  
        RETURN 
  
  END;
  </pre>