This SQL code retrieves the nth Maximum and nth Minimum values in the column specified in from the table . The argument will be accepted in the runtime by SQL:

As you know, VBScript doesn’t support the declaration of optional parameters in subroutines or functions. So, if you have a function declared as: Myfunction(p1,p2,p3), to simulate optional parameters, you’d have

This tip is an extension of a Design Pattern called “Service Locator” for the J2EE architecture. Generally, the “Service Locator” pattern returns a home object by merely accepting a string,

You can use STL binders to use binary function objects as unary function objects in many STL algorithms which need them. Suppose you need to find the count of strings

The Java API provides a class called java.util.Observable which can be extended by any Java class. The child class can then be an “observable” class and other objects can “observe”

To shutdown Windows, just type the following code: Shell “shutdown -s -t 00” To restart windows: Shell “shutdown -r -t 00” Here’s the key: -s means shutdown. -r means restart.

In Visual Studio, when you select an item on a form you’re building, the Property Grid appears and lets you set various properties (e.g. background color, width, height, text color,

Many of the STL algorithms have two versions, with one version taking one less parameter than what the second version takes. The one with lesser parameters implies its default logic

You cannot change the value of a nodes checkbox in the event treeview_NodeCheck as explained in this tip. Besides that, the event doesn’t fire at all when clicking a nodes

For persisting Java objects in a file, use java.io.ObjectOutputStream. ObjectOutputStream writes primitive data types or Java objects. Persistent storage can be accomplished by using a file for the stream. Only