Viewing 15 posts - 61 through 75 (of 147 total)
Andrew,
What you said makes sense. Thank you for clarifying this. I noticed the SQL documentation mentioned 'schema scoped' but I wasn't sure what that meant. After reading your post I...
August 4, 2019 at 4:48 pm
Andrew and Joe,
You guys were right. In the foreign key table, I had some blanks in the projectMgrID column so there was not a corresponding match in the primary key...
August 4, 2019 at 4:06 pm
Jeff Moden,
I started to read the first link you posted. Before I progress any further, I should understand the concept of splitting. I came across this website which has...
August 4, 2019 at 3:45 pm
Jeff,
I'll take a look at the tally table and the other link you posted. I think this is way beyond my level but I'll look into it and see what...
August 4, 2019 at 12:43 am
DesNorton,
You mentioned:
The N'xxx' is an indicator that the contents between the quotes is unicode (which is what the function is expecting). The N'U' does in fact...
August 3, 2019 at 11:36 pm
Jeff Moden,
Thanks for your input. I am familiar with IF statements and looping statements a bit. Your example will help me to get use to the programming side of SQL...
August 2, 2019 at 2:49 am
DesNorton,
I see what you are saying now. I was reading it wrong. But what about my second post where SQL says 'CK_isActive' is not a constraint? I don't...
August 2, 2019 at 2:47 am
DesNorton,
That makes sense. I have found that when I execute more than one statement at once, some of them seem to execute even though some may error out.
August 2, 2019 at 1:19 am
DesNorton,
I see what you are saying now. I was reading it wrong. But what about my second post where SQL says 'CK_isActive' is not a constraint? I don't understand why...
August 1, 2019 at 12:44 am
Jeff,
It looks really nice now.
CREATE TABLE Costpoint.ProjectCodes
(
isActive tinyintNOT ...
August 1, 2019 at 12:22 am
Edit: I ran this part of the code only to see if I can isolate the problem:
ALTER TABLE Costpoint.ProjectCodes
DROP CONSTRAINT CK_isActive;
and I got this error message:
July 31, 2019 at 4:18 am
Jeff (and others),
I forgot to ask, when you posted my code formatted with vertical alignment, you used Pascal case for the column names like I did. Did you do that...
July 30, 2019 at 1:12 am
"Correct. It doesn't matter if it's tabs or spaces. And, if you consider the column names example I gave, now you also understand one of the reasons why I like...
July 30, 2019 at 1:07 am
Jeff Moden, The vertical alignment of the code looks very nice. I can see how it is much easier to read. What do you mean with SSMS doing...
July 27, 2019 at 6:37 pm
Jeff Moden,
The vertical alignment of the code looks very nice. I can see how it is much easier to read.
What do you mean with SSMS doing vertical selection?
I take that...
July 26, 2019 at 10:46 pm
Viewing 15 posts - 61 through 75 (of 147 total)