Transcript SQL Server Notes

SQL Server
• Microsoft SQL Server 6.5 (startup menu)
• We’ll use two facilities
– Enterprise Manager: to build your db
– ISQL_w: to run queries
• Use this for the next homework
Enterprise Manager
• I’ll meet with your group to setup the DB
• You’ll define tables
– keys
– foreign keys
• That’s all you’re concerned about
ISQL_w
• Select trusted connection option & Connect
• Select a database to query
– cse444sql for your next homework. This is a
movie database.
• Type in your SQL
• Check/Print results
• Many tuples in cse444sql
– Rather than print out result, write # tuples
returned for homework
Connecting to your DB
• Info at http://iinetsrv.cs.washington.edu
• Once you implement your database, mail
support@cs with:
– full names and mail aliases of the members of
your group
– group name
• So your db can exchange info with your
web pages via ODBC
In the Visual Interdev Project...
• More info at the iinetsrv site
• Support worked very hard...
• Create a new project using the Web project
wizard
• Use iinetsrv.cs.washington.edu as the server
Space will automatically be allocated for you on
iinetsrv using this method.
Otherwise, must allocate space through support.
Visual Interdev...
• Chose to create a new web
• Add data connection to your project
– Select your database (after support sets it up)
– You can view the tables in your interdev proj
• Can add and modify web pages like files
• Add data commands to the pages
• Lots of help files under: Web Applications,
Web Projects
Inserting Data in your DB
• Use the table view in Interdev
• Use the INSERT statement in ISQL_w
INSERT INTO student(name, sn, year)
VALUES (‘jim’, 9434876, 4)
• Use the INSERT statement in your code
– Your code will send SQL queries to the DB