XML has been around for many years; with the release of the Microsoft .NET technology, XML has become even more popular. Microsoft’s development tools and technologies contain built-in features to support XML. The advantage of using XML and its related technologies is that it is the major foundation of both the Internet and .NET.
My goal in this chapter is to introduce you to the most essential XML concepts and terminology and the basic techniques for using XML with SQL Server 2012. This will enable you to handle some common programming tasks while writing a software application.
This chapter will cover the following:
- Defining XML
- Understanding why to use XML
- Benefits of storing data as XML
- Understanding XML documents ...