From the course: SQL Server 2014 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Intro to XML - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Intro to XML
- Before we get into talking about some of the specific capabilities that Microsoft SQL Server has when working with XML, let's just talk about XML in general. XML is a text-based format that is human readable and is most commonly used for the exchange of information. Here's a sample of XML. The data is surrounded by descriptive tags, each tag with an opening and closing pair. The tags themselves are delimited with the greater than and less than sign. XML has two primary ways of providing information. One is called attributes and the other is called elements. Here is an example of some XML attributes where the information John and Smith exist inside of the tag person. Inside of the person tag we have the name of the attribute, which is first name. Then the equal sign, and then in quotes, the value of the attribute, which is John. And we can have multiple attributes in the same tag. The alternative way of displaying this exact same information would be to use elements, where the data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.