====== Exec Stored Procedure ====== EXEC procedure_name @param_name1 = value_1, @param_value2 = 'value_2'; where the value with quote is string type or datetime, and the one without could be int, float,... and you might have any number of parameter as the procedure needed.