From the course: Learning Azure SQL Querying

Unlock the full course today

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

Inserting new data into a table

Inserting new data into a table - Azure Tutorial

From the course: Learning Azure SQL Querying

Start my 1-month free trial Buy for my team

Inserting new data into a table

“

- [Instructor] In the result set for our product table, look at the values for the black and red helmets. Say that the manufacturer is going to send us a new green helmet. To add this to the product table, we will write a SQL statement that covers the first CRUD operation, which is C for create. To add rows to a table, we will use an insert statement. Delete the query that the SQL editor put into this tab. Type INSERT INTO in all capital letters. You don't have to use capital letters in the keywords of SQL statements, but it's a common convention. And when you have a lot of SQL statements sitting together, it helps your eyes to see the different statements. Then type the table name you want to insert a row into, so type Product and you'll see the query editor autofill with the table owner and the full table name. Click on the auto-complete entry and then press Enter. Inside a set of parentheses, include a comma delimited list…

Contents