Use XML Data Type instead of NTEXT on SQL Server

martinjt / elmah

Automatically exported from code.google.com/p/elmah

Apache License 2.0

0 stars 0 forks source link

Use XML Data Type instead of NTEXT on SQL Server #265

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

Use the XML data type instead of NTEXT with SQL Server.

The XML data type allows usage of XQuery to query the XML itself.  This can 
typically be used to extract columns of data from XML nodes for filtering, 
reporting, etc, and has the potential to be used in computed columns as well.

See the XQuery language reference for more information.
http://msdn.microsoft.com/en-us/library/ms189075.aspx

Original issue reported on code.google.com by msumer...@gmail.com on 6 Jan 2012 at 4:07

GoogleCodeExporter commented 8 years ago

NTEXT has been used so far because SQL Server 2000 did not support XML when 
ELMAH was initially release and we've had to maintain backward compatibility 
throughout 1.x. It's certainly something worth considering for the next majore 
release.

Original comment by azizatif on 6 Jan 2012 at 6:44

Added labels: Component-Persistence

GoogleCodeExporter commented 8 years ago

Yes, I would also strongly vote *FOR* using the XML datatype instead of NTEXT !

Original comment by mscheu...@gmail.com on 12 Jan 2012 at 6:23