Reputation: 113 Stalwart
- Active Posts:
- 1,317 (1.08 per day)
- 14-January 10
- Profile Views:
- Last Active:
- Yesterday, 08:06 PM
- OS Preference:
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Dream Kudos:
Posts I've Made
Posted 15 May 2013Awesome! Thanks for your help!
Posted 15 May 2013Does this look correct?
Posted 14 May 2013Ah that makes sense. I can't believe I didn't think about that. I believe I got everything set up except for the junction table. Would someone please look over this to make sure I'm creating the junction table correctly?
CREATE TABLE Document_Users ( documentID int NOT NULL REFERENCES Document(documentID), userID int NOT NULL REFERENCES Users(id), isOwner int NOT NULL, PRIMARY KEY(documentID, userID) )
Posted 13 May 2013When I go to create the user table using the query below I seem to get an issue with the table name.
CREATE TABLE User ( id INT PRIMARY KEY NOT NULL, fName varchar(25) NOT NULL, lName varchar(25) NOT NULL, email varchar(40) NOT NULL, gender varchar(1), password varchar(12) NOT NULL, )
The error I get is
Incorrect syntax near the keyword 'User'.
Does SQL Server just not like for you to use User has a table name or am I missing something else?
Posted 10 May 2013Alright, I just have 2 questions. With the removal of the Parent Company table, you made the Company table have a parentID and you made it have a foreign key to the companyID in the same table. Did I read that right?
Second, I tried searching for Microsoft parameter notation, but kept coming up with something else other than what you did. Could you provide me with either an explanation of it or a link to the documentation for it so I can read up on it?
- Member Title:
- Microsoft Senior Student Partner
- 21 years old
- June 11, 1991
- Albertville, AL
- Years Programming:
- Programming Languages:
- ASP.NET, C#, Java, SQL