How do I state my foreign key in my Create Table?

Question

How do I state my foreign key in my Create Table?

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

Sean Lange - Wednesday, February 22, 2017 8:35 AM
sgmunson - Wednesday, February 22, 2017 8:21 AM
Ed, I agree with you 100%. Mr. Celko posts in a manner that makes people feel disrespected, and frankly, I'm sick of seeing it. It's a shame this forum did not retain the ability to filter out the posts of certain users. Yeah, you MIGHT miss something, but in this case, nothing of value. "Standards" in a field like RDBMS's are guidelines, and not necessarily rigid rules that must be followed or the death penalty is applied. He really needs to get off his high horse and deal with the real world as it is, instead of how he thinks it should be. And maybe, ... just maybe, he should think first instead of just rigidly follow his own "rules". Note that his profile says he's an author. Hope he makes enough to get by, because as a contractor doing actual database work, he wouldn't last long.
LOL. You might look into Joe's resume before you say he wouldn't last long. 😉 From what everyone says he is the nicest person in real life. And he intentionally has an online persona of a derogatory arrogant bully. He has stated that is because of his way of thinking that coincides with some spiritual way of learning or some such rubbish. I think he truly means well but he has repeatedly been bashed by many people over the years to tone down his posts but to no avail. As they say, don't feed the trolls and they will eventually look for food elsewhere.

Yeah, Sean, I've heard about his "intent", and sorry, but I'm not impressed. If his suggested solutions are any indication of the nature of how he works, I'd have to stick with my original conclusion about how long he'd last. However, ... that said, I do TRY to not feed the trolls. Sometimes, though, it's kinda hard to avoid, because after you see so much of it, you just get sick of it. And I don't know about you, but his online persona kinda screams "STAY AWAY FROM ME !!!! FAR, FAR, AWAY !!!!".

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

sgmunson - Wednesday, February 22, 2017 8:49 AM
Sean Lange - Wednesday, February 22, 2017 8:35 AM
sgmunson - Wednesday, February 22, 2017 8:21 AM
Ed, I agree with you 100%. Mr. Celko posts in a manner that makes people feel disrespected, and frankly, I'm sick of seeing it. It's a shame this forum did not retain the ability to filter out the posts of certain users. Yeah, you MIGHT miss something, but in this case, nothing of value. "Standards" in a field like RDBMS's are guidelines, and not necessarily rigid rules that must be followed or the death penalty is applied. He really needs to get off his high horse and deal with the real world as it is, instead of how he thinks it should be. And maybe, ... just maybe, he should think first instead of just rigidly follow his own "rules". Note that his profile says he's an author. Hope he makes enough to get by, because as a contractor doing actual database work, he wouldn't last long.
LOL. You might look into Joe's resume before you say he wouldn't last long. 😉 From what everyone says he is the nicest person in real life. And he intentionally has an online persona of a derogatory arrogant bully. He has stated that is because of his way of thinking that coincides with some spiritual way of learning or some such rubbish. I think he truly means well but he has repeatedly been bashed by many people over the years to tone down his posts but to no avail. As they say, don't feed the trolls and they will eventually look for food elsewhere.
Yeah, Sean, I've heard about his "intent", and sorry, but I'm not impressed. If his suggested solutions are any indication of the nature of how he works, I'd have to stick with my original conclusion about how long he'd last. However, ... that said, I do TRY to not feed the trolls. Sometimes, though, it's kinda hard to avoid, because after you see so much of it, you just get sick of it. And I don't know about you, but his online persona kinda screams "STAY AWAY FROM ME !!!! FAR, FAR, AWAY !!!!".

Agreed 10000%. By no means am I trying to defend him or his abhorrent online behavior. And yes....FAR FAR AWAY!!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SoCal_DBD Hall of Fame Points: 3382 More actions · Answer 3

sgmunson - Wednesday, February 22, 2017 8:21 AM
Ed, I agree with you 100%. Mr. Celko posts in a manner that makes people feel disrespected, and frankly, I'm sick of seeing it. It's a shame this forum did not retain the ability to filter out the posts of certain users. Yeah, you MIGHT miss something, but in this case, nothing of value. "Standards" in a field like RDBMS's are guidelines, and not necessarily rigid rules that must be followed or the death penalty is applied. He really needs to get off his high horse and deal with the real world as it is, instead of how he thinks it should be. And maybe, ... just maybe, he should think first instead of just rigidly follow his own "rules". Note that his profile says he's an author. Hope he makes enough to get by, because as a contractor doing actual database work, he wouldn't last long.

I will not read his responses any more and agree, it's shameful he cannot be barred from this community. There is NO place for his pious attitude on this forum - published author or not.

ScottPletcher SSC Guru Points: 101099 More actions · Answer 4

Frankly, the attitude wouldn't bother me so much if what he was posting made sense in the real world. But it just doesn't. Making identifier values character(10) simply because you never do math on them? That's just terrible given the huge performance implications. I'll admit, I too think identity values are vastly overused by most developers, particularly as "default" clustering keys (when such a thing should not exist), but they do have their proper place.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".