Parameter Info (IntelliSense)

  • Article

The Microsoft IntelliSense parameter in bold indicates the next parameter that is required as you type a function or system stored procedure.

The parameter list is also displayed for nested functions. If you type a function as a parameter to another function, the parameter list displays the parameters for the inner function. Then, when the inner function parameter list is complete, the parameter list reverts to displaying the outer function parameters.

To view Parameter Info for functions or system stored procedures

  1. After the name of a function, type an open parenthesis as you normally type to open the parameters list. After you type the name of a system stored procedure, type a space as you normally type to open the parameter list.

    IntelliSense displays the complete declaration for the function or the parameters for a stored procedure in a pop-up window just under the insertion point. The first parameter in the list appears in bold.

  2. As you type the parameters, the bold font changes to reflect the next parameter that you need to enter.

  3. Press ESC at any time to close the list, or continue typing until you have completed the function.

    For a function, if you type the closing parenthesis you also close the parameter list.

To turn off Parameter Info, clear Parameter information on the General property page for the desired language in the Options dialog box. For more information, see Modifying IntelliSense Options.

Note   IntelliSense is not implemented for SQL Editors.