Ninja's_RGR'us (11/27/2008)

---

I meant this by quirky update :

Update table set @Var = UpdatedColumn = @Var + WhateverIttakesToEvalutateThisVariable

This must be used with a index hint on a temp table to...

Hi Ninja's_RGR'us,

No. As far as I know, UPDATE is not quirky at all in SQL Server 2000. What do you...

There is a huge problem with this technique. IDENTITY values are not guaranteed to be consecutive; for a variety of reasons there may be gaps. Those will invalidate the results...

I knew my reply was going to be considered wrong before I submitted, but I just didn't want to submit an incorrect reply, even though I second-guessed the author's mind.

WHEN...

It's technically correct that bcp.exe can only replace the contents of a file and output from SQLCMD can be used to append as well, and if the purpose of the...

JohnG (11/20/2008)

---

Additionally,

1. It doesn't properly support a legitimate value of -1 as -1 is being used to indicate that the value is not numeric.

2. An explicit CAST is needed in...

Hi donnelcyril,

You already gave the reply - the null values are the...

I do. Thanks for sharing your results, David! 🙂

How about this:

INSERT INTO #t3

(documentId, pages, docPath)

SELECT d.DocumentId, d.pages,

...

skjoldtc (11/6/2008)

---

Good question. Not because of the question itself but because of one of the answers. I went on a tangent to relearn the goals of ACID. That reminded me...

Thanks, Anirban 😉

SanjayAttray (11/5/2008)

---

CREATE INDEX NotAllowed

ON Dest (Value)

WITH(IGNORE_DUP_KEY = ON);

go

Msg 1916, Level 16, State 4, Line 1

CREATE INDEX options nonunique and ignore_dup_key are mutually exclusive.

ignore_dup_key should...

Jamie Longstreet (11/5/2008)

---

The negative ("This option may NOT be specified...") - urrgh... semantics. Does it mean that it can be but that you shouldn't because it doesn't make sense but...

Steve Jones - Editor (11/3/2008)

---

Hugo,

As always, thanks for catching the mistake. I have clarified the question.

It is a deprecated feature, but there are plenty of 2000 instances out there and...

Though I got the point, I don't think I liked this question very much. First, because it applies to a data type that has been on the deprecated list since...