You can find a good (though advanced) discussion of that here.
That should get you started and thanks for visiting the site.
The stored procedure and trigger language is a language created to run in a database.
I'm assuming that the PKValue field is an identity column so I don't need to supply it a new value.
Our create prodedure statement will look something like this: Notice that each parameter's data type is defined along with the parameters.
It also doesn't return anything to the client to indicate success or failure or what record was inserted.