installing SQL server

  • I am the absolute definition of a newbie.

    I am just starting my first SQL class online and the book doesnt tell me where to install SQL server 2000 Evaluation

    when I open it, the path is automatically

    C:\SQLEVAL

    Do I leave it that way and continue with the install

    or... do I want to put it in program files ?

    I have no clue and have not heard back from my instructor on this matter

     

  • Usually it goes under program files but it doesnt really matter. Install away! Post questions as you have them, we don't mind newbie questions at all.

  • Thankyou sooo much for your help, I am sure I will be back to ask more questions as time goes on.

  • Is there anywhere that gives you step by step instructions on this... with screenshots ?

    I am completely frustrated with this.

  • The typical install is very straight forward, just a wizard where all the defaults usually work. Where are you stuck?

  • ok... it is installed... now have to do this... but no clue how to do it

    Issue the following two statements from your Query Tool:

    ----------------------------

    use RecipesExample;

    select * from ingredients;

    ----------------------------

    Enter the number of rows that were returned.

    what is the Query tool and how do I find it ... and where should I see the number of rows returned ?

  • It sounds like you've installed the software which is a good step.  The sql query you have above will run on a database called "RecipesExample" and a table called "ingredients".  In Sql server, you can have many databases.  In each database, you can have many tables. 

    In your tutorial/book/class documentation or notes, were there instructions about adding the "RecipesExample" database to sql server?  Within that database there would be a table called "ingredients".  Once you add the database, then someone can walk you thru running the query above.

     

  • Thankyou so much,, I got it now I think

  • Irene,

    You are lucky to have so many helpful members on this forum.

    But, I am surprised that your course-instructors or materials did not give you any help. 

    Perhaps you would be better off dropping this course and buying a couple of good books (step by step).

    I am sure, members will give you a list of books if you need.

    Best wishes

    r_achar

     

     

     

     

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply