What does the NULLIF function do?

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

(Continued from previous question...)

What does the NULLIF function do?

Answer: Returns NULL if the two expressions passed in are equal.

Explanation: This function returns NULL if the two expressions passed into it are equal.

(Continued on next question...)

Other Job Interview Questions

• In Service Broker for SQL Server 2005, you encounter the following setting in one of your queues...
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• Using Report Builder, which of the following statements is correct about formatting numbers?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• Where can you view the list of server-scoped DDL triggers?
• What What does the term ACID refer to?
• What is the granularity in seconds of the timestamp datatype?
• More...