Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2003
    Posts
    107

    Unanswered: how to add data to my tables (was "SQL Server Newbie")

    Hi. I just set up my first sql server database and I've managed to connect to it via ASP as a test.
    I'm not sure how to add data to my tables. In MS Access, you can edit the table and add records. How do I do that in SQL Server?
    I'm using the Enterprise manager tool to create tables.... does it have something i can use?

    Thanks

  2. #2
    Join Date
    Dec 2004
    Posts
    4
    The sky's the limit on how you can add and edit data in SQL tables, but comparable to what you said about editing tables in access... In EM, you can right click a table then select to open table and return all rows, top or specifiy a query. (I usually use top 1 if I plan on adding rows)

    I would advise using query analyzer to do any editing though. Much easier and more efficient IMHO.

  3. #3
    Join Date
    Feb 2003
    Posts
    107

    Returning rows...

    When I try to return rows by right clicking on the table, i get an error that says:
    An unexpected error happened during this operation.
    Query Designer encountered a Query Error: Unspecified error.

    ??

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If all else fails, and you have primary keys on your tables, you can always just link the tables in MS Access. As Dr_Clong advised, though, you probably want to pick up a book on Transact-SQL. I liked Sams Publishing's "Teach Yourself in 21 Days" book.

  5. #5
    Join Date
    Feb 2003
    Posts
    107

    Query analyzer

    ok... so it sounds like i have to write sql INSERT statements to add data...??
    Sorry if that's a dumb question.
    I'll look up some books on transact sql.

  6. #6
    Join Date
    Dec 2004
    Posts
    4
    I don't know your setup or for that matter what could be causing your error, but I agree the best way to start out is by educating yourself on SQL Server tools and TSQL.

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    1. Stop using Enterprise Manager

    2. Start Using Query Analyzer

    3. Open Books Online and Leave it Open

    4. INSERT INTO myTable99(Col1, Col2, Col3) SELECT 'x','y','z'

    5. Or bcp data in from flat files

    6. Have a Margarita!

    7. Post here often

    8. Have Another Margarita

    9. Go to 8.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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