What does this WHERE clause evaluate to?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does this WHERE clause evaluate to?

What does this WHERE clause evaluate to? (there are rows with NULL values)
select top 10 *
from MyTable
where Myid = NULL


Answer: Unknown

Explanation: The expression "MyID = NULL" evaluates to Unkown rather than any true or false condition.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...
• What type of update did you perform?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What does this code return? select 6 | 7 Figure it out without running it.
• You restart your SQL Server on a Sunday morning after some maintenance ...
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• Using Report Builder, which of the following statements is correct about formatting numbers?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• What can be used to ensure that a field in a table only accepts a certain range of values?
• More...