x

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][1]

[1]: http://ask.sqlservercentral.com/storage/temp/71-Screen+shot+2012-02-10+at+12.35.55+PM.png
more ▼

asked Feb 10, 2012 at 05:48 AM in Default

sporty gravatar image

sporty
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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
more ▼

answered Feb 10, 2012 at 06:34 AM

sporty gravatar image

sporty
0 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x151

asked: Feb 10, 2012 at 05:48 AM

Seen: 560 times

Last Updated: Feb 10, 2012 at 06:34 AM