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
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...
answered Feb 10 '12 at 06:34 AM