Description_reference contains 2 rows with the value August 2012

........ ???

Thanks Steve.

I guess in some cases these kinds of defect are discovered because the "user" knew there ought to be some orders.

The "information in the system" depends where...

Thanks Florian

I am primarily interested in defects in software, which leads to an interest in testing.

There is surprsingly little information about testing SQL statements for correctness and robustness.

So I...

Thanks Jeffrey. Amazing how similar science is to religion - heresy. orthodoxy, beliefs, holy wars etc.

I am primarily interested in defects in software, which leads to an interest in testing.

There...

Gift Peddie - You seem to have a downer on "theory".

Codd's "theory" was what was accepted as the way ANSI SQL Null was to work.

Field is a term used...

You seem to have a downer on "theory".

This "theory" was what was accepted as the way SQL Null was to work.

Field is a term used to describe the contents...

There are many articles on use of SQL Null. Its is NOT jsut a question of "evil ptifalls" - although they certainly exist and can cause problems.

The issue is how...

Well RBarry Young - my sympathies. You seem to have been up against principled views. . Tut. This is science not religion and rational thought is needed!!!

Null, default values, normalisation...

Gosh Gift Peddie you have a long memeory! My last posting was early 2008 I think.

I think you have a principled view on Null, which is fine as far as...

Matt:

OK OK 🙂

Given the same database schema with the same evnironment then...

The point I was trying to get at was that a correct mathematical proof is inviolate to time. Since...

Jack Wrote " ... just few months of tutoring "

Well exactly - a few months of tutoring!

Jack Wrote " ... never developed an application where all the data was...

Thanks Joe.

Joe wrote "....lot of time over the years explaining what NULL is/isn't."

Actually this is my main concern, UP to a point its alright SQL database DBAs and experienced developers...

Matt:

I think the discourse runs like this:

* Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft

* A relational database is a database that conforms to the...

Jeff - I meant 2 rows whose data represented the same entity.

Obviously that would be a big mistake as an entity must be unique !

Jeff wrote "the correct answer is that no one has yet defined what a NULL in the age column is actually supposed to represent"

Which presupposes that it only represents a...