Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2008-06-13 : 09:19:25
|
| Hi alli want to know where i am wrong in the following Command in the context of Sq Server 2005 (Developer Edition):Select * from Customers For XMLAfter Executing i receive the [Unable to parse query text] Error message !!!should i enable or disable special service for take the advantage of XML in sql server (2000 or 2005)/Could anyone help me please?Kind Regards. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-13 : 11:11:28
|
| You should specify modeSelect * from Customers FOR XML AUTO |
 |
|
|
ZarrinPour
Yak Posting Veteran
66 Posts |
Posted - 2008-06-13 : 14:07:02
|
quote:
Originally posted by visakh16
You should specify modeSelect * from Customers FOR XML AUTO
Hi visakh16Thanks 4 ur replyI did what you said BUT still i receive the mentioned error message?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-13 : 14:09:59
|
| What are fields of you table? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-13 : 14:21:45
|
| http://www.dotnetforce.com/Content.aspx?t=a&n=211 |
|
|
|
|
|
|
Select * .....For XML ........