Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Friday, July 24, 2015 8:43 AM
Points: 3,600, Visits: 2,723
"ON DELETE CASCADE" was the basic of this question. Glad it had no tricks.

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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 16, 2015 4:01 AM
Points: 1,356, Visits: 304
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:46 AM
Points: 1,716, Visits: 2,361
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