Statistic functions – that is MAX, MIN, SUM, AVG, VAR, VARP, STDEV and STDEVP – don’t take Null values into account. Usually this isn’t a problem with the SUM function,

Sometimes Microsoft documentation can be, well lacking is a kind word, and one is reluctant to call tech support when they smoke your credit card first, and ask questions later.My

The standard way to test whether two object variables point to the same object is through the Is operator, as in: If obj1 Is obj2 Then … However, when both

The SELECT TOP N query always return exactly N records, and arbitrarily drops any record that have the same value as the last record in the group. To see what

If you omit the ALL clause in an UNION statement, SQL Server must delete duplicate values, which in turn means that it has to sort the two sub-resultsets that have

The SQL language offers a simple and effective way to quickly move all records from a table to another table with same field structure, that is same fields’ name, type

Through its java.util.zip package, Java provides you with an easy mechanism to compress/decompress files. Here is a method called zipDir, that shows how to recursively zip a directory structure. Note

This is a Class to perform rotr and rotl as known in standard C implementations and a rotate with carry implementation. The technique used is to determine which bits within

You can access Java system properties within your queries (most useful when running in embedded mode; in server mode, you will see the server’s properties, not the client’s). VALUES (CLASS

This example shows how to create a method, and then an alias for that method, to act like the Sybase-style SUBSTRING built-in function. (Note that you can also perform methods

Java’s exception handling mechanism provides developers with an elegant, easy-to-use way to handle exceptional situations in their programs. For example, if there is a file operation to be performed, one

[float]s and [double]s are useful for graphics and possible statistics.However they are not recommended for certain calculations requiring absoluteaccuracy, such as when they involve money . That’s because the results

The java.net.ServerSocket class implements a server socket. A server socket waits for requests to come in over the network. It performs some operation based on that request, and then possibly

Sorting arrays of primitive types (byte, char, double, float, int, long, and short) is easy.Example: import java.util.*;import java.awt.*;class SortDBL // Sorts an array of randomly generated double values.{ public static

This interface defines the way in which objects are to be compared. Anobject that implements this can be sorted as easily as any primitive, such asthe [String] class… import java.util.*;import

It is a common task for servlet (JSP) developers to have to display something with a server-based operation (calculation) that wastes a lot of time. Suppose you have a very

If you have a whole-number counter, for example in a loop or record counter, consider using a datatype of PLS_INTEGER instead of INTEGER or NUMBER. When declaring an integer variable,

You can use methods of java.lang classes for all of the functions found built-in to other databases. For example, you can call the static method java.lang.Math.abs, which is similar to

Direct access of a NULL in a column does not cause any problems in SQL-J. If you use that value as a parameter in a Java method or as a

If you’ve ever used SQL commands against the ADO Connection object, you might have had a problem allowing the user to enter text that contains an apostrophe: ADOCon.Execute “Insert Into

ADO and RDO do not support Oracle cursor types; neither Microsoft nor Oracle drivers provide appropriate conversion. As a result, you cannot use Oracle stored procedures from VB or Active

It’s often useful to sort a DBGrid field in either descending or ascending order. You do this by using the HeadClick event and the DataField property of columns. You must

When you write Insert statements, it can be difficult to accommodate the possible values end users might enter into a textbox. The most common task is replacing single quotes with

If you use an MSFlexGrid control to display data returned in an ADO recordset, you can use this code to dynamically populate the grid?including the header row?with the information in

In Microsoft Knowledge Base article Q217114, “How to: Implement Array Arguments in Visual Basic COM Objects for Active Server Pages,” Microsoft says you can’t pass an array to a COM

The MSFlexGrid tries to automatically determine how to justify text. If the first character is numeric, then that cell will be right-justified. If it is an alphanumeric character, then that

If you usually use DSN-less connections with ADO, you know it can sometimes be a pain to figure out the correct connect string. In that case, you can let the

Often you need a data structure similar to a two-dimensioned array or collection, but you need to manipulate it. For example, you need to sort on certain columns, filter certain

Sometimes you want to give your DataGrid the ability to edit fields, while the original data in the field is highlighted. Normally, you can click on the field to start

If you’re developing multiuser Jet-based applications, you probably know about Microsoft’s msldbusr.dll. It allows you to read the Jet lock files and get the correct number of connected users and