Tip Bank

In a typical user registration form, you may ask for quite a lot of data, such as the first and last name, full address, phone and fax numbers, e-mail address,

When dealing with COM, unfamiliar database schemas, or regular code, sometimes you will find yourself wondering whether to test if a variable is Null by using either: IsEmpty(varname)IsNull(varName)If varname =

Defining a UNIQUE constraint on a computed column is a straightforward process, as the following example shows: CREATE TABLE T1 (col1 int NOT NULL,col2 AS col1 + 1 UNIQUE) However,

There is no T-SQL function for getting product of rows in a particular column. For example, say you had a table like this: –/////////////////////////////select * from #tbltest order by mydate

I’ve been bitten by MSVC++’s inability to have templated methods without the whole class being templated and today I figured out a workaround that allows you to maintain most of

Sometimes a program crashes or simply misbehaves on release builds. This is very frustrating because usually you have to ship the optimized release version. The most common reason for this

An application’s memory footprint grows over time and may eventually cause the application to crash. There are many things that lead to a slow memory burn. One of these is

Say you need to change the look and feel of a JSP page being loaded, depending upon the calling URL. You can use hidden form fields to determine the look

Say that you have a page loaded from another page, and that in this page you have a “Save and Return” button that does something and returns to the previous