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
Burlingame, CA?Mergers and acquisitions happen. IT environments expand as new applications are added to keep pace with business goals. New technologies spring up, as others that were once the latest,
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
eb services are more complex to deploy than Web sites or intranet applications. They are based on intricate platforms, or runtime environments that, like any software, can have their own