Stored procedures are a nice way to encapsulate some business logic inside your database. This post is not about learning how to write stored procedures but instead deals with the specifics of implementing optional parameters in your SQL Server stored procedures. You can learn more about stored procedures at Wikipedia or Google.The most common use of stored procedures is to return some data based on some passed in parameters. More often then not they need to orzcle multiple parameters.
You have an employees table that has the employee id, first name and last name. It provides several features that make developing powerful database innput very convenient. Probably not a common use case but I have seen it pop up from time to time. The question how do I pass XML from a queue or web service and insert it into a DB table using XMLTYPE.In this example I create a basic table with the field PAYLOAD of type XMLTYPE.