Abstract
XML is growing in usage every day. Some relational purists will look at XML and shake their heads. However, XML is complementary to relational technologies. In fact, a lot of XML is structured just like relational data. Is that good? Probably not, since the two models are best at their intended data formats: XML for semistructured data, and relational databases for relational data. Plus, the semantics of storing, querying, and modifying XML is what confuses most relational people. As you’ll see, the XML query language, XQuery, looks nothing like Transact-SQL (T-SQL). However, you can use the two technologies together to solve your business problems.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Robert Walters
About this chapter
Cite this chapter
(2008). SQL Server and XML. In: Accelerated SQL Server 2008. Apress. https://doi.org/10.1007/978-1-4302-0606-4_16
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0606-4_16
Publisher Name: Apress
Print ISBN: 978-1-59059-969-3
Online ISBN: 978-1-4302-0606-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books