The best way is to use SPT parameters.

SQLEXEC(, "EXEC mysp ?Param1, ?Param2, ....")
* OR
SQLEXEC(, "EXEC mysp @Param1=?Param1, Param2=?Param2, ....")

>
>How do you pass named parameters from VFP to SQL Server using SPT? (If it is possible)
>
>TIA.