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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-25 : 18:59:32
|
| rajesh writes "I Used Select * from tbl for xml auto It shows the result but that is not complete i.e table "tbl" has 40 records but the query shows only 7 recordsPlease tell what's the problemThanks regardsrajesh" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-08-25 : 19:30:56
|
| Does it say how many rows affected at the bottom?Something like (40 row(s) affected)Scroll all the way to the bottom. Sometimes it will put multiple rows without a line break.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-25 : 19:36:15
|
| It's not supposed to with XML on. It's just using the multiple lines to wrap the text for you. Set your results maximum characters per column to 8000 and run the following query with the option to put results in text instead of grid. Select * from master..sysdepends for xml auto Notice that it cuts all the characters off at 2034. If you run this in grid, it does the same thing. SQL Server QA has no idea what one record is in XML.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
For xml auto not returning full records