From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Return data with SELECT and FROM

Return data with SELECT and FROM

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial

Return data with SELECT and FROM

“

- [Instructor] Our Two Trees database has a products table that includes data on a couple of different olive oils that we've already entered in. In order to make the process of querying the data a little bit more interesting, I want to greatly expand the number of rows that this table contains. We can do that by running a script that I've saved in the exercise files. First, make sure that you selected the Two Trees database in SQL server instance. Then come up to the File Menu and choose Open File. From there, we'll browse into the chapter six folder and find the Two_Trees_Products.sql file. You can open that up and we'll take a look at what it's going to do. First, it's going to remove all the rows from the products table. And we're doing that by running a delete statement, but we're not specifying a WHERE clause to limit the delete. So this is going to remove everything from the table, and then we're going to insert into…

Contents