ravidas (8/16/2012)

---

I am new to this .hope now you will be able to help me out

SELECT 'xml' AS 'colname/@classcode'
FOR XML PATH('colname'),TYPE

I need the answer as <colname classcode='xml'/> <colname>

SELECT 'xml' AS '@classcode'
FOR XML PATH('colname'),TYPE

ravidas (8/17/2012)

---

Hi


you have assigned the value for column name but you are not actually closing it

you xml solution will be <colname classcode="xml" />

but in need the solution as <colname classcode="xml" /> <colname>

<colname classcode="xml"></colname>

declare @xml xml
set @xml = '<colname classcode="xml"></colname>'

select @xml