News


I just wanted to return from sql server data as xml. This is very easy to do, because sql server has a build-in suppot for that.

select Id, Name from Extensions FOR XML RAW('Extension'), ROOT('Extensions')

But using this query, the returned column has name like XML_F52E2B61-18A1-11d1-B105-00805F49916B

It's been some time when I manually created a sql query, so I lost few minutes to think, how to alias this column using the AS keyword.

Correct query looks as follows

select (select Id,Name  from Extensions  FOR XML RAW('Extension') , ROOT('Extensions')) as alias

 

I see I just need to remember some basics about sql/tsql.. Too much NHibernate I see.