You are here: Re: Referential Integrity problem « MsSQL Server « IT news, forums, messages
Re: Referential Integrity problem

Posted by Jeff North on 10/02/60 11:49

On Sun, 4 Jun 2006 16:22:48 +0000 (UTC), in
comp.databases.ms-sqlserver Erland Sommarskog <esquel@sommarskog.se>
<Xns97D8BAFABD743Yazorman@127.0.0.1> wrote:

>| Jeff North (jnorthau@yahoo.com.au) writes:
>| > On Sat, 3 Jun 2006 17:34:14 +0000 (UTC), in
>| > comp.databases.ms-sqlserver Erland Sommarskog <esquel@sommarskog.se>
>| ><Xns97D7C71728295Yazorman@127.0.0.1> wrote:
>| >>| I can't really say what might be the problem
>| >>| in this case, but I guess that if you add triggers into the mix, there
>| >>| can be intersting results.
>| >
>| > No triggers at present but it looks as though triggers might be the
>| > only option.
>|
>| What I wanted to say that combination of cascading DRI (had it been
>| permitted) and triggers in this case could have lead to interesting
>| results.

I could well imagine what sort of 'problems' could arise :-)

>| And since a trigger could be added later, my suspicion that the
>| mere possibility is enough to disallow the multiple cascade path.
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация