Not to detract from XML, but from a programmer's perspective you better also learn JSON as well since some databases (MongoDB, CouchDB, Persevere) and services/frameworks are leaning in that direction...

To allow for nulls we try to emulate the ISNULL functionality with custom ISNULL functions by datatype and set the Parameter in the sp to NULL. To null numeric...