Write a SQL statement that creates a stored procedure that adds a new record to the Part table, and returns the value of the newly created PartID PK value in an out parameter. The field values of the record to be added should be passed into the stored proc as input parameters. The assumption here is that the Part table has its PartID PK field as an idendity field, or surrogate PK, meaning a numeric field that is auto-generated by the db system.