How to add a text to an xml element

DECLARE @Courses TABLE
(
DeleteAllCurrentRecords VARCHAR(1),
DeleteCurrentRecord VARCHAR(1),
Code VARCHAR(10),
Campus VARCHAR(10)
)

INSERT INTO @Courses VALUES('Y', 'Y', 'T-SQL', 'MSFT')

select DeleteAllCurrentRecords AS '@DeleteAllCurrentRecords'
        , DeleteCurrentRecord AS 'Course/@DeleteCurrentRecord'
        , Code AS 'Course/Code'
        , Campus AS 'Course/Campus'
from @Courses
FOR XML PATH('Courses')

Good Luck :)

Visit WWW.SQLSAGA.COM for more sql related stuff.