Tom.Thomson (3/4/2010)

---

SQL is actually a procedural language, and not a declarative language. At least two reasons: (1) you can write a number of statements to make an SQL programme...

Well, to paraphrase a famous line "It depends on what the meaning of the words...

AND doesn't have any cursors hidden inside of it. 😀

Thanks, Paul. I did just try a simple test to compare it with sp_MSforeachdb, and I've been getting about the same numbers for both.

I suppose I should post it...

There's some pretty cool tricks that you can play with it too. Besides the obvious nesting trick above, you should also see how it tears up an INSERT..EXEC.

Heh, just because I never finished my "50 Ways to Leave Your Cursors" series doesn't mean that I haven't been working on it. 😀

Lynn Pettis (3/3/2010)

---

I hope you have current backups. IIRC, the waste basket on Server may not be big enough to allow you to recover the database files like you...

You can, but generally the match string must not have a wild card at the beginning, for this to work.

Paul White (3/3/2010)

---

RBarryYoung (3/2/2010)

---

And you know, this would all be a lot easier and simpler if you did this in a set-based way, instead of using a CURSOR and WHILE...

OK, I think that I have it now. We were talking about slightly different things, but what you've explained did manage to kick me into seeing it correctly. ...

Well, I've been chewing over exactly how to do what I promised to do (explain my position wrt Logical IOs in clearer terms), in a constructive way that doesn't turn...

I just realized, there are actually three different things that the doc refers to as "XML Bulk Load" at one point or another. Which one did you mean? ...

Paul White (3/2/2010)

---

And I would (genuinely) guess at Chicago. But why ask about the Bears?

It's a meme isn't it. I was never any good at...

SQL-Student:

Can you prefix the DTD into the beginning of your XML file before importing, or do you have to keep them separate?

Lutz:

No, its in the DTD too (plus, if it was supposed to be embedded HTML, it would have to be entitized). So I guess it is...