devxlogo

December 22, 2001

Control the Concatenation Results in SQL Server

You can control the concatenation results using SQL ServerCONCAT_NULL_YIELDS_NULL(T-SQL). Depending upon the CONCAT_NULL_YIELDS_NULL settings, the concatenation results are treated as null or empty string values. When SET CONCAT_NULL_YIELDS_NULL is ON,

Separate Trace Statements

Sprinkling TRACE statements in your code is a common practice during development and debugging, especially when refereshing UI code, or multi-threading, etc.Usually, people write something like this: TRACE(“My Trace “);

Declaring Conditional typedefs

Conditional typedef declarations can be useful in cross-platform development. For example, some platforms define long as a 32-bit integer. Other platforms treat long as a 64-bit integer. You can create

How to Re-open a Nested Namespace

As strange as it may seem, C++ doesn’t allow you to re-open a namespace using a qualified name; you can re-open it only by using its nested name. For example,