Selecting the top N rows in a table is no problem in SQL Server, but how to select the 2N to 3N rows is not as clear. Using the following

Here is sample code: import java.security.SecureRandom;public class UniqueNumberGenerator{ static final SecureRandom random = new SecureRandom(); static final StringBuffer buffer = new StringBuffer(30); static { random.nextInt(); } public static String getNextUID()

It seems common knowledge that I/O streams and JDBC database connections are resources that need to be released as soon as they are no longer needed. Not so common knowledge

Many books about JDBC and most of JDBC-related sample code floating around seems to assume that JDBC is used directly, meaning that database connection is established by the DriverManager, and

If you’re like me, and sometimes need to modify Active Directory data from an ASP page where the user is either anonymous, or doesn’t have admin privileges, you need a

The equals() method in the String class is commonly used to compare two strings for equality. However, this method returns true only if the argument is not null and is

This is a fast and versatile function for loading comboboxes.I have not included a ComboBox.Clear, to make it possible to load multiple recordsets to the combobox. This makes it more

One of the many functional methods of rolling back transaction(s) in a VB application is as follows: 1) In the procedure containing the Begintrans/CommitTrans methods, declare a Boolean Procedural variable

One of the best ways to improve performance in a distributed application is to avoid sending unchanged data back to the server for updating. I use the following strategy to

Here is a function for extracting the ID3 tag from a MP3 file. Add the following lines of code into a Module: Public Type ID3Data Tag As String * 3

Double buffering is a process of doing all the drawing first in the memory and then displaying the entire screen at once. It is called double buffering because two drawing

Have you ever gotten a nasty error when using

This is a bit tricky. You can

Suppose you have some C++ code that you’d like to convert to the Java programming language. While doing the conversion, you come across the following code: void getStats(int data[], int&

The performance of

When using a timer control, it is important to prevent re-entry.This occurs when the processing in the _Timer event takes long enough to still be executing when the next _Timer

You can pass Object parameters to a sub ByVal just as you pass other parameters. But what is the difference between passing Objects ByVal and ByRef, since an object variable

Writing basic classes needs no more definition from the programmer than just declaring a few member functions and variables. But, what if you needed to design a class that was

Use the following code: Public Function RemoveChar(ByVal str As String, ByVal strChar As String) As String ‘ Function: RemoveChar ‘ ‘ Desc: Extracting requested character from given string. Return value

An easy way to debug ActiveX EXE Components is to run ActiveX EXE project in the IDE VB environment and then run your client application or client project. But before

You can use #ifdef & #endif to comment out a block of code that already has multi-line comments.For example: #ifdef COMMENTThis #ifdef removes all nested Code & Comments Code…/* Comments…*/

A linked list is a dynamically created area where data can be stored. It contains certain algorithms for collecting data (alphabetically, numerically, etc.). This is like an array but an

You can do this while testing a true/false condition that has a set third variable as shown in following loop: if ( x < y) z = true; else z

You can declare the counter of even the most deeply nested loop as a ‘register’ variable. For example: for (int i = 0; i < 100; ++i){ for (register int

If you are using MS Visual C++ to develop your application or DLL, then this may help. MS Visual C++ 6.0 introduces new linker optimization options: /OPT:WIN98, which is set

Global inline functions, consts and typedefs have internal linkage.That means that the declarations in these two files do not interfere with each other: //File1.c typedef int T; const int a

This tips explains how to list members in an initialization list in the order in which they are declared. Take a class Array: class Array {private: int *m_piData; // ptr

Enum mbOfficeAppConstants mbWord = 0 mbAccess = 1 mbExcel = 2 mbPowerpoint = 3 mbOutlook = 4End Enum’ Check whether the specified Office application is present’ Note: require GetRegistryValue” Example:’