How to Run a SQL Query

• Step 1. Find a computer in the Sieg building which has SQL Server installed (most of the undergrad labs should have SQL Server).
• Step 2. In Windows, goto Start, Programs, Microsoft SQL Server 7.0, Query Analyzer.
• Step 3. A Box labelled Connect to SQL Server should show up.
  • In the input box labelled SQL Server, type ISQL01
  • Select the Use SQL Server authentication option.
  • As Login Name type cse444
  • As Password type WeRock! (please follow the exact capitalization)
  • Press OK
  By doing the last step, you connected to the SQL Server machine called ISQL01, using the cse444 account. You will use this account to complete your homework. For the project, you will get a different account.
• On the new opened windows, there is an option called DB with a pull-down menu. You should have SQLDB selected in that menu (this should be selected by default after you login).

  SQLDB is the name of the database you will work on. On the ISQL01 SQL Server, there are multiple databases, but the SQLDB database has been created just for you to do your homework.

• Try to write a query now. Type

  select * from Elections2000

  Type Ctrl-E to run the query (or click on the little green arrow on the menu). If everything worked alright, you should get back the results of the query - 3 tuples.

  Congratulations - you just run your first query.

• Elections2000 is the name of a table inside the SQLDB database. As you see, it contains three tuples.