ITM 706 Lecture Notes - Lecture 3: Database, Negation, Semicolon
12 Apr 2019
School
Department
Course
Professor
Document Summary
Follow the instructions up to and including step 7 in the file "connect sql and attach. Db" (from d2l), then follow the instructions below. In the new panel that is opened, write your query and then click on the execute icon. All the questions here have the queries (answers) and resulting tables shown for your learning purposes. For this lab, you will just have to repeat/re-create the queries on your computers and see if you can achieve the same results. It results in the display of all the columns in the student table. As there is no row filter clause, all the rows (students) in the table are displayed. Notice the ; at the end of the command. This part of the standard of sql and some dbms"s will give an. 1 error message if it is not present. However, microsoft sql server is more forgiving, and the queries will run without it.
