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 Wednesday, March 27, 2013 8:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 17,817, Visits: 15,744
EZ PZ today.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1435920
Posted Wednesday, March 27, 2013 11:31 PM


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 one Ron

I think you have posted two questions on this topic earlier. If it is possible, then please post more questions on this topics with different kind of scenario. This will give us very good information. It will help us to get some more interesting scenario.





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

Post #1436265
Posted Thursday, March 28, 2013 12:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 2,157, Visits: 879
Thanks for the Easy Points
Post #1436277
Posted Thursday, March 28, 2013 8:15 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: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
L' Eomot Inversé (3/26/2013)
Hugo Kornelis (3/26/2013)
I think you're reading a bit too much into the code used to create some sample data, Tom. I suspect ROn used this method to eaily visualize which rows belong together, but not with any other intention.

Oh, I don't for a moment imagine that Ron was intentionally breaking 1NF, or that he even noticed he was doing. And of course it's completely irrelevant to the question - any old table will do as long as it has a foreign key. That's why I said it was a good question apart from the strange wording of the answer options.

But I've often been hit by junionr developers seeing something and thinking "Oh, that's neat, perhaps I can use that" when the something they saw was absolutely terrible practice but acceptable in a particular context because it wasn't relevant there. So I try to avoid doing such things even when they are not relevant to thetask at hand, and believe that everyone should do so. Especially in contexts where they are likely to be seen by a lot of not particularly experienced people.


I agree in principle but can we expect everyone who writes a QotD to check their question for best practice in the coding? Might people be deterred from posing a QotD if they're worried about getting the coding practice picked to pieces? Having said that, was there any need for a mixture of @val1 and @val2 to be used in the setting of the first column. Would the question have achieved the same result if some arithmetic on just @val2 was used?
Post #1436491
Posted Monday, April 1, 2013 2:10 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: Thursday, October 16, 2014 7:54 AM
Points: 959, Visits: 561
paul.knibbs (3/26/2013)
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.


+1


--
Dineshbabu
Desire to learn new things..
Post #1437376
Posted Friday, April 5, 2013 12:10 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:25 PM
Points: 2,400, Visits: 1,482
Nice question. I do not care about the wording, it worked for me.

M.


Not all gray hairs are Dinosaurs!
Post #1439403
Posted Thursday, April 18, 2013 1:36 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, October 10, 2014 7:07 AM
Points: 3,545, Visits: 2,654
Another good question on cascade after the one on delete.
Post #1443639
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse