I was tried to study xml in sql2008. when I running this query using "TYPE" always giving me error result. (please see below images) what is my wrong here ? cos this is simple sintax ? this is same result whe I using FOR XML, ELEMENTS, ROOT('test')
please help me... thank you very much
![alt text]: http://ask.sqlservercentral.com/storage/temp/71-Screen+shot+2012-02-10+at+12.35.55+PM.png
asked Feb 10 '12 at 05:48 AM in Default
I found my mistaken is. in the same time I am connect with sql instance for SQL2000. thats why when using TYPE, I was always getting result error...
tahnks you very much...cheer's
answered Feb 10 '12 at 06:34 AM