From: Antony C. <an...@sm...> - 2006-11-23 13:18:43
|
On 23 Nov 2006, at 13:01, Adam Marshall wrote: > I use MSSQLServer 8 and even though the constraints are accepted, I > think > I'm correct in saying you cant actually do a cascade delete! Well test it my friend then we can work with facts! > > MySQL has changed since last looked, which is great news. > > adam > > > | -----Original Message----- > | From: bod...@li... > | [mailto:bod...@li...] On > Behalf Of > | Peter Crowther > | Sent: 23 November 2006 12:54 > | To: Bodington developers > | Subject: Re: [Bodington-developers] Deleting users > | > | > From: Adam Marshall > | > ON DELETE CASCADE doesn't work with MySQL and MS SQLServer, > | > what would you do about those DB's? > | > | Get a supported MSSQL version - it's supported on SQL Server 2000 and > | newer using the same syntax Antony describes. SQL Server 7 is at the > | end of its life, and sites running it should be thinking about > | upgrading. > | > | - Peter > | > | > ----------------------------------------------------------------------- > -- > | Take Surveys. Earn Cash. Influence the Future of IT > | Join SourceForge.net's Techsay panel and you'll get the chance to > share > | your > | opinions on IT & business topics through brief surveys - and earn > cash > | > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > | _______________________________________________ > | Bodington-developers mailing list > | Bod...@li... > | https://lists.sourceforge.net/lists/listinfo/bodington-developers > > > > ----------------------------------------------------------------------- > -- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to > share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php? > page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bodington-developers mailing list > Bod...@li... > https://lists.sourceforge.net/lists/listinfo/bodington-developers |