I discovered the SELECT NULL syntax by observing the internal SQL statements issued by Oracle when...

AJ (9/4/2008)

---

Good question, but I think it is being confused, including by me, with an UPSERT (as the previous posts' referral to MERGE indicates too).

This question needs more information to...

Hugo Kornelis (9/4/2008)

---

Personally, I prefer SELECT * as it indicates checking for a row, not checking for a specific value or so. But that's just personal preference. From a performance...

Re:

I'm afraid I don't understand the complaint here. There are solutions to get the end result you want, with the error-protection you want. They are easy to...

Jack,

Yes, the non NAMESPACE query works. It is what you'll see published in every [rant: too simple] example.

Since the WITH clause is used for both CTEs as well as...

Just to clarify the following:

The other method will actually return all of the rows per the query and set the value of the last row returned -- which can be...

Jack,

Yeah, I managed to come up with the same screwy solution myself. I'm not real happy, but it works.

I submitted the same problem to a Microsoft support forum to...

Hugo Kornelis (7/8/2008)

---

GSquared (7/8/2008)

---

Just to test this, I tried the following on a table with just over 1-million rows of data:

(...)

I had used fast_forward in the past, based on what...

In all of the read-only cursors that I have coded I always specify FAST_FORWARD.

I have never used STATIC as the overhead to copy the data into tempdb can be prohibitive...

but definitely not if you "restart the instance with the -D parameter that specifices the database name and new path deparated by a colon". You have to give only the...

James Rochez (7/2/2008)

---

JohnG (7/2/2008)

---

We need better quality control on the QOD. E.g., correctly spelling the names of stored procedures, etc.

Most of us understand the intention and overlook some spelling...

See BOL for details, syntax, and examples.

1. Use CONTAINS vs. FREETEXT as FREETEXT has a number of limitations.

2. The CONTAINS wildcard character is an asterisk (*).

3. Note the limitations of...

We need better quality control on the QOD. E.g., correctly spelling the names of stored procedures, etc.

Most of us understand the intention and overlook some spelling errors (e.g., with...

Very true. With all disciplines, it is one thing to be "book smart", it is another thing to...

The...