By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
CONVERT(xml,
(
SELECT
Apple = '',
Banana = '',
Orange = '',
Pear = ''
FOR XML RAW ('Fruits'), ELEMENTS
)
);
| (No column name) |
|---|
| <Fruits><Apple /><Banana /><Orange /><Pear /></Fruits> |
SELECT
Apple = '',
Banana = '',
Orange = '',
Pear = ''
FOR XML RAW ('Fruits'), ELEMENTS, TYPE;
| (No column name) |
|---|
| <Fruits><Apple></Apple><Banana></Banana><Orange></Orange><Pear></Pear></Fruits> |