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

CASCADE - 2 Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 8:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:20 PM
Points: 5,615, Visits: 25,201
Comments posted to this topic are about the item CASCADE - 2

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 #1435232
Posted Monday, March 25, 2013 11:39 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:27 AM
Points: 1,890, Visits: 2,329
+1 today
Last time for DELETE cascade question I lose the points so this time first I prefer to refer BOL before answering this question



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1435267
Posted Tuesday, March 26, 2013 3:08 AM


SSC Eights!

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

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 953, Visits: 2,171
Good one, thank you for posting;

I actually selected 1 and 4 and really not sure what crossed my mind and I ended up selecting the other two... which lead to #facepalm; (and my friend sitting next to me, observes, ... and goes... "what happened man... did your gf dumped you?" and that lead to #headdesk)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1435335
Posted Tuesday, March 26, 2013 3:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:27 AM
Points: 1,890, Visits: 2,329
Why today there are no replies from people?


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1435344
Posted Tuesday, March 26, 2013 5:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 1,639, Visits: 5,619
This seemed so simple I went and ran the code, sure there must be a catch of some kind--turns out there wasn't, it was as simple as is seemed at first viewing.
Post #1435389
Posted Tuesday, March 26, 2013 5:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
Easy one, 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 #1435407
Posted Tuesday, March 26, 2013 5:52 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 PM
Points: 8,830, Visits: 9,388
Apart from the messed up wording of the answer options this is a good question.

It would have been a better question if more care had been taken with editing the answer options.

And intensly I dislike the horrible violation of 1NF - code examples like this risk teaching really awful habits to inexperienced people who see them.


Tom
Post #1435409
Posted Tuesday, March 26, 2013 6:59 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, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
Glad I got this one right... after the last two where I knew the correct answer and just picked the wrong one... I as getting skeered



--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1435452
Posted Tuesday, March 26, 2013 6:59 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 11, 2014 6:36 AM
Points: 1,820, Visits: 2,172
Thanks for the question Ron.

I'm developing a bit of paranoia. Even when the question is easy for me, I figure that I am missing something.

As Andy Grove said, only the paranoid survive. (They require therapy and medication. But they survive!)


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1435453
Posted Tuesday, March 26, 2013 7:02 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thanks for the great question.
Post #1435454
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse