Re: Oracle Closed World
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 24 Jun 2012 19:04:11 +0200
Message-ID: <a4ovkeFd53U1_at_mid.individual.net>
On 23.06.2012 07:07, zigzagdna_at_yahoo.com wrote:
> I found SQL Server t-sql to be far behind Oracle's
> PL-SQL. T-SQL even does not have a for loop, it only has while loop.
> There is no if then elseif only if then else. It does not have any
> record type.. t-sql is very primitive.
Date: Sun, 24 Jun 2012 19:04:11 +0200
Message-ID: <a4ovkeFd53U1_at_mid.individual.net>
On 23.06.2012 07:07, zigzagdna_at_yahoo.com wrote:
> I found SQL Server t-sql to be far behind Oracle's
> PL-SQL. T-SQL even does not have a for loop, it only has while loop.
> There is no if then elseif only if then else. It does not have any
> record type.. t-sql is very primitive.
It's not the worst thing to motivate developers to move from procedural code to SQL... :-) Procedural is often used because it is easier to understand for humans. But unfortunately you can bring any database's performance down with the wrong set of procedures and triggers.
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sun Jun 24 2012 - 12:04:11 CDT