RandomlyKnighted's Profile User Rating: -----

RandomlyKnighted's Photo
Reputation: 113 Stalwart
Group:
Authors
Active Posts:
1,317 (1.08 per day)
Joined:
14-January 10
Profile Views:
41,756
Last Active:
User is offline Yesterday, 08:06 PM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
XBox
Your Car:
Ford
Dream Kudos:
300

Latest Visitors

Icon   RandomlyKnighted who has an interview with Adtran at 1:00? This guy! :D

  1. Awards
  2. About Me
  3. Blog

Posts I've Made

  1. In Topic: Issues with table design

    Posted 15 May 2013

    Awesome! Thanks for your help!

  2. In Topic: Issues with table design

    Posted 15 May 2013

    Does this look correct?

    Posted Image

  3. In Topic: Issues with table design

    Posted 14 May 2013

    Ah 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)
)

  4. In Topic: Issues with table design

    Posted 13 May 2013

    When 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?

  5. In Topic: Issues with table design

    Posted 10 May 2013

    Alright, 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?

My Information

Member Title:
Microsoft Senior Student Partner
Age:
21 years old
Birthday:
June 11, 1991
Gender:
Location:
Albertville, AL
Years Programming:
4
Programming Languages:
ASP.NET, C#, Java, SQL

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://randomlyknighted.com
LinkedIn:
http://www.linkedin.com/in/thughes01
Twitter:
tyler_b_hughes

Comments

Page 1 of 1
  1. Photo

    ishkabible Icon

    26 Jun 2011 - 18:13
    happy belated birthday!!
  2. Photo

    chinalwb Icon

    07 Jun 2011 - 21:33
    Your birthday is coming, Happy Birthday to You~!
  3. Photo

    v0rtex Icon

    18 May 2011 - 04:24
    Hey, Hope your GWAToolbox program is coming along nicely :)
  4. Photo

    no2pencil Icon

    11 Apr 2011 - 19:57
    GO BLUEJAYS!
  5. Photo

    modi123_1 Icon

    14 Feb 2011 - 13:33
    Just a heads up on your sig image: 364x166 != 400x80.
  6. Photo

    Dogstopper Icon

    05 Nov 2010 - 03:58
    GO BRAVES!
  7. Photo

    Alex6788 Icon

    25 Oct 2010 - 10:03
    Posted a new scaled down signature in the request signature thread
  8. Photo

    Alex6788 Icon

    22 Oct 2010 - 15:45
    I'm in your profile.
Page 1 of 1