When "SET CONCAT_NULL_YIELDS_NULL ON", concaten

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

(Continued from previous question...)

When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?

The answer is Yes.

(Continued on next question...)

Other Job Interview Questions

• What is an Index in MS SQL Server?
• What does RDBMS stand for?
• What is the size a Page in MS SQL Server?
• What can you do with the Bulk Copy operation in MS SQL Server?
• What is a simple way to detach a database that is not in use in MS SQL Server?
• What does Field refers to in MS SQL Server?
• Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is a Torn Page in MS SQL Server?
• More...