Microsoft Query won't let me edit parameter types for my SQL procedure.

Microsoft Query

Microsoft Query won't let me edit parameter types for my SQL procedure.

To create parameters in a SQL stored procedure and set the data types:

  1. On the File menu, click Execute SQL.
  2. In the SQL statement box, create your query using fixed arguments for the procedure, and then click Save.
  3. On the View menu, click SQL.
  4. In the SQL statement box, replace each fixed argument with a question mark (?).
  5. Click OK, and then click Parameters on the View menu.
  6. To change the data type for a parameter, click the parameter and then click Edit.