Re: [Bodington-developers] Deleting users

[Adam M. <ada...@ou...>]

Ah - time for me to re-investigate methinks

adam

| -----Original Message-----
| From: bod...@li...
| [mailto:bod...@li...] On Behalf Of
| Peter Crowther
| Sent: 23 November 2006 13:24
| To: Bodington developers
| Subject: Re: [Bodington-developers] Deleting users
| 
| > From: Adam Marshall
| > 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!
| 
| create table pri(p int not null primary key)
| create table furrin(f int not null references pri(p) on delete cascade)
| insert into pri values(1)
| insert into furrin values(1)
| delete from pri where p=1
| select * from furrin
| drop table furrin
| drop table pri
| 
| The select * returns 0 rows, as expected if this works.  Tested on SQL
| Server 2000 SP4, SQL Server 2005 SP1.
| 
| 		- 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