bitbucket-25253 (7/26/2010)

---

webrunner

Easy enough to find out ...

CREATE TABLE #T(userid INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5...

Well, just don't...

David Portas (7/25/2010)

---

Guaranteed access is surely also important for derived relations as for base relations. Yet by the time Codd introduced the 13 rules he abandoned the idea of relational...

Matt Miller (#4) (7/25/2010)

---

Not that I agree with the argument, but I believe the reasoning had to do with not wanting to deal with the unertainties around non-determinism. So...

Matt Miller (#4) (7/24/2010)

---

...why is just a fancy way to say - use a SET statement up front to set the parameter's value (using a function if need be), THEN...

Another rule (number 2) in its 1990 version. This one hadn't changed much from the 1985 version.

RM-1 Guaranteed Access

Each and every datum (atomic value) stored in a relational...

Thomas-282729 (7/24/2010)

---

With due respect to Alex, it is not as elastic as you think. A good barometer for whether a given piece of logic belongs in the database is whether...

Hi Hugo

No need to be sorry about the self-promotion when it leads to an interesting blog entry with a useful external reference. The "much ado" paper contains several excellent...

Mike C (7/22/2010)

---

Let's walk through this briefly and see what steps would be required to implement the original query to perform it in logical order steps:

select

left( 'abc', T1.v...

UMG Developer (7/23/2010)

---

I don't understand, that is a basic SELECT statement with no quirky update or aggregation, so since you have one record in the table you will get one...

That erroneous view is a fairly natural consequence of treating NULL as a value which exists in all domains instead...

Mike C (7/22/2010)

---

Sorry to hear you're leaving T-SQL :crying: Unfortunately you probably won't find much love in any dialect of SQL. The problem (?) is that the SQL...

Steve Jones - Editor (7/22/2010)

---

I tend to agree with you, Gail, but a reference is a reference for purposes of discussion.

I do think this is a thorny issue. Would welcome...

I think I agree with that. And I would add that anyone who says "X can't be a type...

peter-757102 (7/22/2010)

---

I find this sort of thing many more times disturbing/dangerous then using a quirky update deliberatly and with full knowledge and documentation. Why? Because I suspect hardly anyone will...