Results 1 to 9 of 9

Thread: table

  1. #1
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Unanswered: table

    i want to create a table for Apartments a separate table for each flat is difficult to create can any body suggests me to solve the prob

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Sure - have one table for all flats.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    then how can i insert many values in the table at a time i know just ex:-
    Code:
     insert into owners values(101,'abacg','Swedan','1254897')
    how can i insert bulk data at a time i am using sql server 2005 vrs

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Where is the data you want to insert? Is it in a text file? On paper? In your head?

    Also, can you tell me exactly what a "flat" is please?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    Quote Originally Posted by pootle flump View Post
    Where is the data you want to insert? Is it in a text file? On paper? In your head?

    Also, can you tell me exactly what a "flat" is please?
    the data is in my mind it is just a example i want to enter data to this following table owners table has around 30 rows so each time it is difficult to insert values by my method the table is below
    Code:
     CREATE TABLE Owners
    (
    FlatNo int primary key,
    Owner varchar(25) NOT NULL,
    OwnerAddress varchar(40) NOT NULL,
    Phone char(15) NOT NULL,
    Year smallint NOT NULL
    )

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    That's programming baby! There is no way to directly port the data from your mind in to the table. You either need to write thirty insert statements or create an interface\ GUI to make inserting easier.

    A third option is to right click the table in SSMS and select "Edit top 200 rows" and then you can type directly into the table.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Also, that table does not look normalised. If someone owns 30 flats are you going to type that owner's personal data in 30 times? You should not.
    The Relational Data Model, Normalisation and effective Database Design
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    thanks for your help i will try to type all at once

  9. #9
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Hmmm...you guys got the "thanks for your help" that quickly because O.P. was faced with the normalization issue and quickly retreated back into the classroom from whence he/she came.
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •