Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Posts
    15

    Unanswered: new to SQL server 2000

    dear sirs, i am new to Ms SQL server 2000,
    And i am also new to databases, I wanted to know is there a tutorial for SQL statements...that is the Structured Query language used in MS SQL server 2000....
    I mean for being an administrator on SQL server 2000, what is the correct procedure....how to go about it??

    regards,
    kanishk

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SQL resource: http://www.w3schools.com/sql/default.asp
    And the manual / help file is always the best place to start!
    George
    Home | Blog

  3. #3
    Join Date
    Apr 2007
    Posts
    15

    return all rows

    dear sir, can you please tell me the difference between, return all rows and return top...??
    When we right click any table from a database, then we go to the option, open table: there it shows
    1>return all rows
    2>return top
    3>query

    i just wanted to ask the difference between the first 2

    regards,

  4. #4
    Join Date
    Jul 2003
    Location
    Romania
    Posts
    8
    Return all rows - as it says return all rows from the selected table
    Return top .. - return only how many rows you specified in the windows that appears when you select this option


    All best,
    Adriana

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by kc3377
    dear sirs, i am new to Ms SQL server 2000,
    And i am also new to databases, I wanted to know is there a tutorial for SQL statements...that is the Structured Query language used in MS SQL server 2000....
    I mean for being an administrator on SQL server 2000, what is the correct procedure....how to go about it??
    You have a lot of reading ahead of you.

    You would do well to learn about relational database management systems (SQL Server is an example of these):
    http://www.google.co.uk/search?hl=en...roduction&meta=
    http://en.wikipedia.org/wiki/RDBMS
    If you are designing databasea then some grounding in database theory & design:
    http://r937.com/relational.html
    The link George gave you will teach you ANSI SQL. SQL Server uses a particular dialect (T-SQL):
    http://msdn2.microsoft.com/en-us/library/ms189826.aspx
    Bol is the SQL server documentation and is excellent. You can access it via enterprise manager and query analyser.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    also, if you are so new, why bother with 2000? 2005 has been out for a while. I would go straight to 2005 if I were you. There's a free version called SQL Express.

    here's a gentle video introduction for express, starting with "what is a database": http://msdn.microsoft.com/vstudio/ex...g/default.aspx

Posting Permissions

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