April 29, 2000

Thanks to the SQL-DMO object model, it’s very easy to list all the available SQL Server 7.0 installations. For example, this code loads all the SQL Servers registered on the

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