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

  Option: fmt151_parameter_list_style = stacked, type: TFmtListStyle.

  CREATE FUNCTION dbo.Fn_gettoporders(
     @custid AS INT,
     @n AS INT, 
     @test AS CHAR)  
  RETURNS TABLE  
  AS  
    <function body>  
  GO        

  • Comma at the end of line

    Option: fmt152_parameter_list_comma_option = after_item, type: TFmtCommaOption.

    CREATE FUNCTION dbo.Fn_gettoporders(
       @custid AS INT,
       @n AS INT, 
       @test AS CHAR)  
    RETURNS TABLE  
    AS  
      <function body>  
    GO        

  • Comma at the begin of line

  • Comma at the begin of line, align parameters.

  • Comma at the begin of line, align parameters, space between comma and space is 1 or n

• Create function/procedure

• IN and OUT keywords in parameter declaration

Parameter in function call

• SQL function
• PL/SQL Parameters in function call