How does an outer join work with a where clause?

Where are views stored in the database?

What does each error code represent?

What are the disadvantages of indexing?

What is the SQL execution order?

In the execution order, does the on clause come before or after the join?

Can I include rollback or commit statements in stored procedures or triggers?

Execution order

If I create a name column that is nullable, add data where some values are null, and then want to make the column not allow nulls without encountering an error, what should I do?