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. …
What Interests You About This Opening?
We’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…
SQL301-Nesting For XML Queries
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…
SQL 301–FOR XML PATH
OK, I’ve covered FOR XML RAW for simple quick XML outputs. Then I covered FOR XML AUTO, while it automatically handles simple hierarchical data, it’s still pretty limited. And last time I covered FOR XML EXPLICIT, which is the end all – be all when it comes to building XML exactly the way you want…
I’ve Passed the 70-433!
I wanted to write up a post about passing my exam, and share everything I learned during this process. I had considered drawing parallels between the certification process and the levels Jedi go through on their way to becoming masters. I think I’m going to keep that one in my back pocket for a while…
What Do You Know About Our Company?
Continuing my series on tough interview questions, I’d like to cover one that can really set you apart from the crowd. This one is testing you on how much homework you do, and if it comes after a couple rounds of screening interviews, tests your memory (or note taking) skills. So, what do you know…
SQL 301-FOR XML EXPLICIT
OK, so far I’ve covered FOR XML RAW. It’s a pretty simple way to crank out some XML when you need to. FOR XML AUTO has better support for hierarchies, but it too has it’s limits. The end all be all for extensibility is FOR XML EXPLICIT. It actually supports some options that you can’t…
SQL 301-FOR XML AUTO
In my previous XML article, I covered FOR XML RAW. It’s useful, if limited. This time I’d like to cover XML AUTO. It’s still limited, but if you’re looking to model simply hierarchical data, AUTO may be the option for you. If you’re looking for more details, I’d suggest checking out the books online article…
Tell Me About Yourself
I’m going to take the next couple posts and cover some of the interview questions people have told me they struggle with the most during an interview. I want to do this to help you. If you ask yourself these questions, you can start building a stock answer to the question. From there, you can…
SQL 301-FOR XML RAW
OK, I need to study my XML queries, so I’m going to write them up as I go. That way you can learn along with me. In a normal query we return the results in either datagrid or text view, right. Well, if we want to transmit the results to another user or a process,…