Inserting Data Code Challenge 2/2

Hi Robert,

When you are trying to insert into a table and not specify the actual columns before the VALUES keyword, the SQL server expects you to supply all the field values, in the same order they were created in the table.

For example, you have the table actors, which normally should have a column called id and another column called name. You can write the insert query in two different ways:

INSERT INTO actors (name) VALUES ('Michael J. Fox');

or

INSERT INTO actors VALUES (NULL, 'Michael J. Fox');

If your first column has autoincrement, it will take the first NULL and assign it the next available number and insert the name on the row.

You can always specify the next number instead of NULL but that will require you to find what that next number is first, and it is actually better to let the SQL server do that for you.