Tip Bank

The following subroutine requires two parameters1) Recordset2) Count of records per page. For example: Call EasyPaging(Rs,10)

Assume that you have a set of classes that need to provide the same functionality but the way they provide it is different. In essence, these are the classes that

The GO Command sends the current batch of Transact-SQL statements to SQL Server as a batch. The current batch of statements is composed of all those statements entered since the

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,

The compiler reports an error if you try to compile a piece of code like the one follows: int x = 9;switch(x){ case 1: int i = 0; break; case

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 “);

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

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,

One of the most overlooked and underused methods of the ADO object is GetRows(). This will quickly retrieve your recordset as a bi-dimensional array in the form of Array(columns,rows). While