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.

Applications that use the Jakarta Persistence API shouldn’t embed too much raw SQL in their code. However, when you need an SQL query for performance reasons or to access the database in a way that ...