Search Problem

[Jaye]

I using the follow query to search data in SQL SERVER EXPRESS
"SELECT Style_id as STYLE_ID, Style_id +' ' +Style_no as STYLEDIS FROM
STYLE for xml auto"

It will return the result in XML format.
when the number of return result larger than 750, the XML will some problem,
like lose the space:
example:
CORRECT: <STYLE STYLE_ID="749" NAME"XXXX"/>
FAIL: <STYLESTYLE_ID="749" NAME"XXXX"/>

How can tell me why this happen and how to solve it

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

I suggest you to post this concern in a SQL NG, you could get a better
explanation there.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jaye" <Ja**@discussions.microsoft.comwrote in message
news:BA**********************************@microsof t.com...

>I using the follow query to search data in SQL SERVER EXPRESS
"SELECT Style_id as STYLE_ID, Style_id +' ' +Style_no as STYLEDIS FROM
STYLE for xml auto"

It will return the result in XML format.
when the number of return result larger than 750, the XML will some
problem,
like lose the space:
example:
CORRECT: <STYLE STYLE_ID="749" NAME"XXXX"/>
FAIL: <STYLESTYLE_ID="749" NAME"XXXX"/>

How can tell me why this happen and how to solve it

[Dave Sexton]

Hi Jaye,

I believe this might be due to the way the sql client handles XML data when it's not consumed by an XmlReader. After a certain
number of characters the remainder gets cut off but I'm not sure if it will cause a single space to be lost in the middle of XML
output.

Try using an XmlReader, obtained from the SqlCommand.ExecuteXmlReader method, to solve your problem.

--
Dave Sexton

"Jaye" <Ja**@discussions.microsoft.comwrote in message news:BA**********************************@microsof t.com...

>I using the follow query to search data in SQL SERVER EXPRESS
"SELECT Style_id as STYLE_ID, Style_id +' ' +Style_no as STYLEDIS FROM
STYLE for xml auto"

It will return the result in XML format.
when the number of return result larger than 750, the XML will some problem,
like lose the space:
example:
CORRECT: <STYLE STYLE_ID="749" NAME"XXXX"/>
FAIL: <STYLESTYLE_ID="749" NAME"XXXX"/>

How can tell me why this happen and how to solve it