Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

CASCADE - 1 Expand / Collapse
Author
Message
Posted Tuesday, April 9, 2013 7:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 3:24 AM
Points: 1,144, Visits: 299
basic nice question
Post #1440330
Posted Wednesday, April 17, 2013 12:27 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, May 23, 2016 5:31 AM
Points: 3,615, Visits: 2,774
"ON DELETE CASCADE" was the basic of this question. Glad it had no tricks.

Post #1443109
Posted Friday, June 12, 2015 5:26 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, July 7, 2016 4:52 AM
Points: 1,435, Visits: 360
Nice, cascading.
It suprished me that in the Message Pane only :
(1 row(s) affected)
is shown.
Post #1693970
Posted Monday, June 15, 2015 11:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:22 AM
Points: 2,172, Visits: 2,930
Nice complicated question. I could do it easily putting two select statement (order & ordertable), before and after delete command. Scored 1 mark.

Thanks.
Post #1694663
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse