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 |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2007-03-16 : 05:33:14
|
| Hi All,How does the storage of TYPED and UN-TYPED XML different from each other? When I "select" TYPED or UN-TYPED XML Column, I could see the same structure only( I mean that the values are stored as string).Thanks,Prakash.P |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-16 : 13:08:50
|
| The storage doesn't differ, both are stored with the xml data type. But typed XML is validated against a schema and untyped XML is not. So if you have an xml column in your table and you do not associate it with a schema, then it is untyped and you can put any well-formed XML in the column. But if you associate a schema with the column then you can only put XML that validates against the schema in that column. |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2007-03-19 : 01:42:13
|
| Hi,Thanks for your reply.I read in an article that the XML column bound with schema is optimized in storage. If both the typed are stored in a similar way, how is the efficiency possible?Thanks,Prakash.P |
|
|
|
|
|
|
XML Data type