mmcclure (11/4/2008)

---

Okay, corrected the code for SQL 2008 (at least this is what worked for me).

/* create the basic table structures needed */

CREATE TABLE [X_DIMENSION]

( [LOC] [int] NULL...

The first example is just wrong. It has a table for one item per row, a table for one item for each column, and a seemingly pointless x_y index table....

We cant both be right.

From BOL:-

Setting Variables and Columns

Variable names can be used in UPDATE statements to show the old and new values affected. This should only be used when...

Can you point me at the documentation that guarantees that behaviour?

> update MyTable

> set NewZip = ZipCode,

> @LastKey = NameKey

That may well work in this example, but...

"Moore's law may be nearing the end for single core chips, but it"

Did you forget to write the rest of that sentance?

The images to illustrate Query tabs and tab groups dont seem very clear, is there something missing from the left hand side of the first two images?

From BOL :-

"The results of an UPDATE statement are undefined if the statement includes a FROM clause that is not specified in such a way that only one value is...

mccork is correct. The correct answer may be right if the question has specified that you were using Enterprise manager. I dont want to rely on EM working in a...

Interesting article, but as someone else mentioned, it has the disadvantage of needing to modify all occurences of where the stored procedure name is used.

An alternative is something like :-

create...

quote:

---

In addition when I need to drop them from my system I just call by the name of the procedure group and...

What score did you get?

quote:

---

Are you connected with the author?

---

No, in fact I haven't even tried using it myself...

I'm suprised noone has mentioned xp_crypt :-

http://www.vtc.ru/~andrey/xp_crypt/