for xml auto with type

hi all,

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

Screen shot 2012-02-10 at 12.35.55 PM.png (15.3 kB)

asked Feb 10 '12 at 05:48 AM in Default

sporty
0 ● 1

(comments are locked)

1 answer:

hi all...

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

sporty
0 ● 1

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

xml x115

asked: Feb 10 '12 at 05:48 AM

Seen: 289 times

Last Updated: Feb 10 '12 at 06:34 AM

for xml auto with type

Follow this question

Related Questions