Re: Oracle NULL vs '' revisited

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