If you were using this query...

I got it wrong because I haven't had my coffee yet. I somehow didn't see the '7' in the list of department ID values. :doze:

I suspected a question like this would be coming soon, so I practiced yesterday! 😎

This example shows how difficult...

Next time, I will read every word in the question. Even though it's only 3 letters, "not" is a very important word!:blush:

Good question (Translation: I got it right).

I would just like to point out that Ringo's last name is spelled Starr.

A 'correct' answer is one that matches the exact set of correct choices. No partial credit, even...

I got 3 out of 4 right. Don't I get partial credit? 😀

My problem is, I couldn't find a clear definition of "Index Structure". It seems to be a loosely-defined term. It's hard to count something I can't define.

Can anyone give a...

SQLServer stores the DateTime in an 8-byte field. The first four bytes are the number of days since 1/1/1900. The other 4 bytes represent some fraction of a second past...

This was a very poorly-worded question, and the answers weren't any better.

By definition, "NULL" means "NULL". They are not equal in a comparison, but that is what NULL means.

NULL does...

For future reference:

I was able to solve this pretty simply. I just needed to add the transaction as a parameter on the ExecuteNonQuery. Setting the transaction property of DbCommand wasn't...