And now it’s time to wrap up the XML in SQL posts. At least, this is the last of the information you’re required to know for the 70-433. Anything above and beyond this is great…just not required. Let’s dive right in! Exist This first method I want to cover is EXIST. With this method you…
Category: Microsoft SQL
SQL 301-The XML Data Type
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. …
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…
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…
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,…
SQL 301-BIDS, The First time around
In my last post, we used the Import and Export wizard to create a simple Load process. We loaded names.csv into a simple table. Let’s open Visual Studio 2008 (Also known as Business Intelligence Development Studio when you’re talking about the version that comes with SQL Server 2008 R2. Once you’ve started it, open the…
SQL 301 — SSIS Import And Export Wizard
OK, let’s dive right into the Import and Export Wizard. If you’re on Vista or Windows 7, hit start, then begin typing “Import and Export Data” It should find it for you pretty quickly. If you’re not on one of those two, look for your SQL 2005 or 2008 folder, and search in those folders…
SQL 301 – Introduction to SSIS
I’ve been getting requests to cover SSIS, so here we go. Over the next few months I’m going to give you a course that will help you go from knowing what SSIS stands for (SQL Server Integration Services) to being proficient. You’ll learn how to work in SSIS. I’ll teach you what many of the…