I agree. And that's a pretty interesting use...

bhovious (8/21/2008)

---

Just to answer the rhetorical questions about building xml by wrapping tag constants around data, rather than use a "For XML" statement, we should remember that a lot of...

I understand. I mistakenly thought that you...

lucian (8/21/2008)

---

Very useful.

I use it to process a comma delimited list of keys or any other list of values that is passed as a parameter to a stored proc.

Now I...

nvanesch (8/21/2008)

---

I really good performance improvement on string concatenation. I guess these problems weren't present in SQL 2000 so much as we didn't have 2GB varchar variables to work with...

I thought...

Paul DB (8/20/2008)

---

WayneS (8/20/2008)

---

Paul DB (8/20/2008)

---

anil_mootha (8/20/2008)

---

Hi,

Why would you prefer to build XML strings manually when you can do it with FOR XML statement.

The very purpose of FOR XML statement...

Paul DB (8/20/2008)

---

anil_mootha (8/20/2008)

---

Hi,

Why would you prefer to build XML strings manually when you can do it with FOR XML statement.

The very purpose of FOR XML statement would be void...

Thanks Steve!

JPJ (8/19/2008)

---

I agree with you wayne.

I have a small issue in addition to that, this line gave me error:

select @MyXMLString = @MyXMLString +

...

Hey all...

I don't know how it happened, but the code in the article is missing some spaces from what I submitted. They should be pretty obvious where that is, but...

The links for Database Mail and SQL Mail are the same.

I thought that Database Mail replaced SQL Mail?

The first choice is also correct:

From BOL:

The REFERENCES permission on a table is needed in order to create a FOREIGN KEY constraint that references that table.

Is there really any difference or advantage between Temp Tables and Table variables? If there is not enough cache on hand and both will eventually hit TempDB - is...

Well, I think building my own house qualifies me as a DIY-er (with lots of advice from the building inspector). I'll work on almost anything... until it involves an engine....