Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL.

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.