Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: Ed Prochak <edprochak_at_gmail.com>
Date: Thu, 23 Aug 2007 19:18:45 -0000
Message-ID: <1187896725.444219.198850@i13g2000prf.googlegroups.com>


On Aug 22, 1:56 am, "Tony Rogerson" <tonyroger..._at_torver.net> wrote:
> > Server statement trigger performs row-actions when the primary key was
> > updated (lining up those INSERTED and DELETED rows may prove
> > difficult...). Having to do a JOIN on the transition tables to get to rows
> > is just nastily inefficient and can be outright wrong.
>
> A reason why the majority of SQL Server folks use a surrogate key in way of
> IDENTITY - imutable.
>
> --
> Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
> [Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
> [UK SQL User Community]

Ah, that is why you like those so much Tony. You are forced to use a crutch and have grown to like it. You have my deepest sympathies.

Ed Received on Thu Aug 23 2007 - 14:18:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US