Since an IN () gets converted to ... OR ... OR ..., <<

That is only a current SQL Server thing. Other SQL products (and Microsoft will probably catch up someday)...

There are no generic "id" in RDBMS, or generic dates, etc. A table has to have a key. Queries do not modify anything. MONEY is an old vague reserved word...

First of all, in SQL a field is part of a column. For example, the year month and day are fields within a date column. The next misconception is that...

>> It's funny how you chastise people for using 1950's technology (which was actually awesome and still has seriously good application in the modern world that a lot of today's...

It is not just rounding in a single computation. When you have a set of floats, you also get skew in the set as a whole, either away from or...

>> Seems like a numeral is the same as a number it just looks different but can be used interchangeably. <<

No, they cannot be used interchangeably. This is the fundamental...

>> You waste space and risk ambiguity by storing dashes in a date? <<

When we were creating the ANSI/ISO standards for SQL, the dashes were in the format that we...

>> Actually an identifier is numeric (integer) because it just makes no common sense to do otherwise. <<

I'm going to assume that you have seen a Harry Potter movie by...

>> I assume, Joe, that you also never write a date with a number in it either, and would write today's date as something like "The sixth of August two...

Back when I was learning Fortran we spent about two weeks on floating-point numbers. Let me give you a simple exercise. Create a list of positive and negative random numbers,...

Unfortunately what you posted is not a table. A table must have a key and those column(s) he cannot be NULL-able by definition.

CREATE TABLE Foobar

(a INTEGER,

b INTEGER NOT NULL PRIMARY...

This is not the purpose of SQL. We are a database language; you really ought to be using a statistical package. You can write out the formula for the normal...

>> So, by this logic, are you saying I can't use things like 1st, or 23rd, as those ("not-")numbers don't represent a quantity and I can't apply maths expressions to...

No, Jeff, an identifier is by its very nature measured on a nominal scale. It is not an interval scale. It is not a ratio scale. It is not a...

> Suppose I want to do a count, grouped by an article and some columns I do not want to group on but I want some examples of the content....