I was wondering if it is possibleÃÂ for a SELECT FOR XML statement to map a row with a NULL value in a column to an empty element in XML?
For example, let's say I have the following table:
CREATE TABLE NetworkAdapter
ID int PRIMARY KEY
The table hasÃÂ one row with the values (10, NULL). Can I use the SELECT FOR XML statement to return the following XML:
<MacAddress /> -- Or <MacAddress></MacAddress>, doesn't matter
Is it possible to do thisÃÂ without using ISNULL on theÃÂ MacAddress column? Or if not, how would yo
View Complete Post