SQL301

SQL301

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

SQL301

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

SQL301

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

SQL301

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

SQL301

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

etl

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

SQL301

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

SQL301

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

SQL301

Sub-query Modifiers

I'll be honest, I thought I knew all there was to know about sub-queries. Turns out, there is something new (at least to me). You can modify your sub-query to

dev

Equals Sub Queries Versus Exists Sub Queries

I'd like to introduce you to the idea that you can replace an equal sub query with an exists sub query. Doing this can change a seek operation to a scan

microsoft sql

Sorting Numbers in VarChar field

Over at Experts-Exchange, I saw a question I get every once in a while.  It all has to do with how SQL Server orders data in a VARCHAR column.  SQL Server

SQL301

SQL 301 – GROUPING

In our previous lesson we covered WITH ROLLUP and WITH CUBE. During that lesson you may have noticed that when we saw the summary rows, the columns had NULL as