> Thanks a lot for your Mail. > > > > I checked in SQL there is a data type 'XML' exist, so I can stored all > the xml data there, similarly how I can achieve in Firebird
The XML data type in SQL Server is more than simple storage, because AFAIK it enables you to execute XPath/XQuery queries against a XML field etc ... Possibly you even can index content (elements, sub-elements ...) there, but I'm not sure about that. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/
