Fill in the order form to get the price

Write a procedure supply name information from the person.person table and accepting a filter for the first name Alter the above store procedure to supply default value if user does not enter any value(use AdventureWorks)