.value() will actually return a NULL value if you have Typed XML. If you create an XML schema with nillable=true then .value will actually handle all the hard work.

i.e)

<?xml...

I've been using https://sourceforge.net/projects/mygeneration/ for a while now. It's not identical to RAP but it's a code generator. The way I have designed my templates solves about 90% of the...

Great series! I've been doing code gen for the past year and I love it. It is true RAD. As for the column naming, why does everyone care so much...

I'm actually wondering how to determine if ALL values are selected ?

I don't want to pass anything to the procedure if ALL is selected. Its just to much overhead and...