clementhuge (10/29/2009)

---

The stored procedure is interesting. However it does require a lot of prerequisites and open security holes that PCI-DSS would not allow (for example like distributed transaction).

Moreover, the stored...

I'm...

I think the key information in the article is that you can use OPENROWSET to turn the output of a stored proc to a recordset.

This message got a bit...

aha....so it really did just stop with the sql script.

Apologies to the author...I'll read again!

Hi Adam,

I thought this article started off great, very clear, well written etc.....but it seemed to suddenly just stop with the sql script.

If you'd 'followed through' to the end, it...

...and for those of us watching from the sidelines, it's been...

Good find, Matt!

I completely forgot / overlooked that quotename takes a sysname parameter.

I used it principally to take care of strings which already have a quote in them. Quotename...

I've found that you can do a surprising amount of new stuff in a database with compatibility level 8..

I say surprisingly because I didn't expect to be able...

Thanks, Paul - High praise indeed! When used appropriately XML certainly has it's place in the SQL world. I'm sure you'll agree 😉

....it's ok, now.

...appears to be javascript related!

Paul,

When I copy / paste your script into SSMS or a text editor, it all appears on one line.

Any ideas what am I doing wrong?

I think the merit in this article lies more in the techniques that are covered, rather than in the premise that it ultimately failed to prove.

The article does show a...

Hi,

I notice you're using very short tag names in your xml presumably to reduce space used.

If you use a typed xml column i.e. associate it with an xsd,...

ifila (7/20/2009)

---

I tried the following code without errors, but it takes forever 🙁

Thanks

declare @skills varchar (100);

set @skills='"c#" and "livelink"';

SELECT DISTINCT Email

FROM (SELECT Email1,Email2,Email3,Email4,Email5,Email6,Email7,Email8,Email9,Email10...

Nice article!

I've used EXCEPT a few times recently - simply cos I could, I guess, and also sometimes (even if it's relatively unknown syntax) it is clearer when reading the...