SQL Parameters

Parameter declaration

Parameter style

• Fit into one line

  Option: fmt151_parameter_list_style = fit_into_one_line, type: TFmtListStyle.

      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

• Create function/procedure

• IN and OUT keywords in parameter declaration

Parameter in function call

• SQL function
• PL/SQL Parameters in function call