@kramaswamy I agree that there would be some performance hit on this, but it shouldn't be much especially if both of the data columns have unique indexes.  Being...

The answer is "yes" (remember the questions is "can I"), but definitely not sure that you would want to - it would also depend on how many columns are in...

Thank you for a great article - although the internet wasn't the same 20 years ago when I started....

I have had the fortune and/or misfortune to be the sole Database...

WITH singleTab([id], [name], [previousid]) AS (
    SELECT t1.id, t1.Name, t2.previousid
    FROM table1 t1
left join table2 t2 on t1.id = t2.id
),
recusive(id, Name,...

While the above solutions work, they give you a different answer than Oracle if any of the values is NULL.  Oracle will always return NULL for the Greatest and Least...

Hi
It seems this topic has come around again, so I will add my 2 cents worth:-)

I come from an Oracle background where PL/SQL has a much broad...

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't mean that should not be any exceptions.

So to...

Good question, although the answer was given away because there was only one answer with "system database". If you had included system database into the list earlier I would...