>I have a stored procedure with 10 params. How do I call it if I only need to pass the 8th and 9th parameters? Do I have to include placeholders for the first 7 in the EXEC statement?

Pass parameters by name

EXEC mysp @param8='whattever', @param9=87