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 12345»»»

CASCADE - 1 Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 10:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Comments posted to this topic are about the item CASCADE - 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1432987
Posted Tuesday, March 19, 2013 10:49 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
All that sql statemens were just for the final show

Nice and easy !!


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1432992
Posted Tuesday, March 19, 2013 10:59 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:19 AM
Points: 981, Visits: 565
I expected there will be some trickery work will be there.. But it's easy and staright forward question..

--
Dineshbabu
Desire to learn new things..
Post #1432994
Posted Tuesday, March 19, 2013 11:01 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:02 AM
Points: 1,372, Visits: 1,566
Dineshbabu (3/19/2013)
I expected there will be some trickery work will be there.. But it's easy and staright forward question..


+1

Nice and easy. Thanks Ron!


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1432995
Posted Wednesday, March 20, 2013 12:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Good question.

In real life scenario, we need to take care of cascade option.




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1433004
Posted Wednesday, March 20, 2013 12:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
Danny Ocean (3/20/2013)
Good question.

In real life scenario, we need to take care of cascade option.


I prefer not to have delete cascade on design .. to let the error display when the constraint doesn't allow it..

well, delete cascase could be a better option for delete based on performance , but with proper indexing , I guess, basic deletes shouldn't be too intensive process ..

and , it keeps of mistakes off the track that's what constraints are for ...


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1433011
Posted Wednesday, March 20, 2013 12:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
demonfox (3/20/2013)
Danny Ocean (3/20/2013)
Good question.

In real life scenario, we need to take care of cascade option.


I prefer not to have delete cascade on design .. to let the error display when the constraint doesn't allow it..

well, delete cascase could be a better option for delete based on performance , but with proper indexing , I guess, basic deletes shouldn't be too intensive process ..

and , it keeps of mistakes off the track that's what constraints are for ...






Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1433016
Posted Wednesday, March 20, 2013 1:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 13,570, Visits: 11,382
Nice basic question Ron, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1433041
Posted Wednesday, March 20, 2013 2:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 2:23 AM
Points: 228, Visits: 284
Basic question designed to seem like a trick?
This applies equally to SQL Server 2005 and 2008 not just 2008R2 and 2012.
Post #1433050
Posted Wednesday, March 20, 2013 2:18 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: Today @ 3:59 AM
Points: 3,315, Visits: 3,581
Nice and clear question - thanks Ron

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1433052
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse