SQL ServerEnterprise ManagerSlide 3Slide 4ISQL_wSlide 6Connecting to your DBIn the Visual Interdev Project...Space will automatically be allocated for you on iinetsrv using this method. Otherwise, must allocate space through support.Visual Interdev...Slide 11Inserting Data in your DBSQL 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 homeworkEnterprise Manager•I’ll meet with your group to setup the DB•You’ll define tables–keys–foreign keys•That’s all you’re concerned aboutISQL_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 homeworkConnecting 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 ODBCIn 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 serverSpace 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 ProjectsInserting 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
View Full Document