hi,

try with this

select * from tablename for xml raw

hi,

try the following query

SELECT DATENAME(month, GETDATE()) AS 'Month Name'