SQL Server create function procedure

• Parameters

  • Fit into one line if possible

    • At the same line as CREATE keyword

      CREATE FUNCTION dbo.Fn_gettoporders(@custid AS INT,@n AS INT, @test AS CHAR)  
      RETURNS TABLE  
      AS  
        RETURN  
          SELECT TOP(@n) *  
          FROM   sales.salesorderheader  
          WHERE  customerid = @custid  
          ORDER  BY totaldue DESC  
      
      GO        

    • In new line

      CREATE FUNCTION dbo.Fn_gettoporders(
        @custid AS INT,@n AS INT, @test AS CHAR)  
      RETURNS TABLE  
      AS  
        RETURN  
          SELECT TOP(@n) *  
          FROM   sales.salesorderheader  
          WHERE  customerid = @custid  
          ORDER  BY totaldue DESC  
      
      GO        

  • Stacked parameters