From the course: Learning Azure SQL Querying

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Solution: Insert a new product

Solution: Insert a new product - Azure Tutorial

From the course: Learning Azure SQL Querying

Start my 1-month free trial Buy for my team

Solution: Insert a new product

“

(upbeat music) - [Instructor] Click on the previous tab in the SQL editor to bring up our last query. In the column list on the second line, after product number, insert the column name color and follow it up with another comma. You could have put the color column anywhere within this comma-delimited list but I usually like to match the order of the columns with how they're stored within the table schema. But how you order the fields in the column list of your SQL statement doesn't matter as long as you match that same order in the value list. So in the value list on line four, I changed the value inside of the name field from green to purple. Then, I changed the green product number from a -G to a -P. And finally, after this product number value, type in single quote, purple, closing single quote, comma, and then click the run button. Click on the next tab where the list of records in the product table is already…

Contents