We’ve spent the last few posts working on getting relational data out of our tables and into XML format. Most of the time, that’s what I’ve used XML in SQL to do. But you’ve got to learn to build on what you know to learn. Today, we’re going to begin storing XML data in tables. …
Read More SQL 301-The XML Data TypeWe’re back to my series on tough interview questions. It’s my hope that by covering these questions, you’re able to put together a plan on how you’ll respond when you actually face these questions. Let’s dive into the next question: “What interests you about this opening?” This question usually comes in about the same time…
Read More What Interests You About This Opening?Given the 4 options I’ve shown you for creating XML output from SQL, you should be able to create nearly any structure you’d want (especially considering FOR XML EXPLICIT). But you may actually c0me across a scenario where you can’t pull off what you want in a single query. When you can’t make a single…
Read More SQL301-Nesting For XML Queries