Tip Bank

It is usual for a web form to have more than one button control. How can you set the default button that should submit the form and raise its Click

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

‘ A base data class that makes it much easier for derived classes to run a ‘ stored procedure to retrieve data or execute a SQL command. (See usage ‘