Re: Opinions on procedural language being introduced into SQL Server 2005
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 08/12/04
- Next message: Calvin X: "User defined function or How Do I Do This?"
- Previous message: David Portas: "Re: Adding an extra record to a result set"
- In reply to: Joe Celko: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Next in thread: G.C.Mandrake: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Reply: G.C.Mandrake: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Aug 2004 07:03:40 +1000
Hi Joe.
Re: >The code will be such a mess that you will never leave Microsoft<
IBM is implementing CLR in DB2 Stinger as well.
Regards,
Greg Linwood
SQL Server MVP
"Joe Celko" <jcelko212@earthlink.net> wrote in message
news:u$QAu1HgEHA.236@tk2msftngp13.phx.gbl...
> "Many tasks that were awkward or difficult to perform in Transact-SQL
> can be better accomplished by using managed code..." <<
>
> I agree with that. But none of them are database tasks.
>
> >> You can now better use the knowledge and skills that you have already
> acquired to write in-process code."
>
> So much for professional growth from Microsoft <g>. "Ogg not like bow
> and arrow. Ogg not learn bow and arrow. Ogg bash food with rock, like
> always!"
>
> Never mind that the old skills are not appropriate for new situations
> "Ogg bash lizard with rock, so Ogg bash Sabre-tooth Tiger with rock and
> it be just fine." To a neanderthal with a rock, everything looks like a
> lizard.
>
> People are forgetting another screw up -- multiple procedural or OO
> languages all mixing together *inside* the RDBMS.
>
> Ever look at the differences in the MOD() functions among programming
> languages? The order of operator precendence? Does the EOF flag go up
> when you read the last record in a file or when you read past the last
> record in a file (pop quiz: how does a Standard SQL cursor do it?). Do
> you have pre-test or post-test loops? How does your language handle 3VL
> in an IF-THEN-ELSE or switch construct?
>
> When the host langauge was outside the RDBMS, you had an interface that
> did conversions and impedence matching. Now all bets are off. The code
> will be such a mess that you will never leave Microsoft. Or interface
> with any other data source.
>
> --CELKO--
> ===========================
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, datatypes, etc. in your
> schema are.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
- Next message: Calvin X: "User defined function or How Do I Do This?"
- Previous message: David Portas: "Re: Adding an extra record to a result set"
- In reply to: Joe Celko: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Next in thread: G.C.Mandrake: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Reply: G.C.Mandrake: "Re: Opinions on procedural language being introduced into SQL Server 2005"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
