What is usually the first word in a SQL query?

Does a SQL Server SELECT statement require a FROM?

Can a SELECT statement in SQL Server be used to make an assignment? Explain with examples.

What is the ORDER BY used for?

Does ORDER BY actually change the order of the data in the tables or does it just change the output?

What is the default order of an ORDER BY clause?

What kind of comparison operators can be used in a WHERE clause?

What are four major operators that can be used to combine conditions on a WHERE clause? Explain the operators with examples.

What are the logical operators?

In a WHERE clause, do you need to enclose a text column in quotes? Do you need to enclose a numeric column in quotes?

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

Will COUNT(column) include columns with null values in its count?

What are column aliases? Why would you want to use column aliases? How can you embed blanks in column aliases?

What are table aliases?

What are table qualifiers? When should table qualifiers be used?

Are semicolons required at the end of SQL statements in SQL Server ?

Do comments need to go in a special place in SQL Server ?

When would you use the ROWCOUNT function versus using the WHERE clause?

Is SQL case-sensitive? Is SQL Server case-sensitive?

What is a synonym? Why would you want to create a synonym?

Can a synonym name of a table be used instead of a table name in a SELECT statement?

Can a synonym of a table be used when you are trying to alter the definition of a table?

Can you type more than one query in the query editor screen at the same time?