This script creates a report of all user owned tables and their columns with data types and nullability information. SET HEADING OFFSET LINESIZE 400SET PAGESIZE 1000BREAK ON TABLE_NAME SKIP 3SPOOL

Use this code: CONVERT(datetime, FLOOR(CONVERT(float, )))

PostThreadMessage is a Win32 API used to post messages to threads. Usually, the message posted is a standard windows message with the window handle set to NULL.When PostThreadMessage is used

Global variables can lead to problems that are difficult to debug. It is very easy, for instance, to accidentally access a global variable from a function when you think you

Private Type OSVERSIONINFO dwOSVersionInfoSize As Long dwMajorVersion As Long dwMinorVersion As Long dwBuildNumber As Long dwPlatformId As Long szCSDVersion As String * 128End TypePrivate Declare Function GetVersionEx Lib “kernel32” Alias

There are fundamental incompatibilities between the ways AWT and Swing draw themselves. Swing classes are pure Java classes that look the same on all operating systems. AWT Java classes are

OBJECT_NAME is a module level constant and ‘PROC_NAME is a procedure level constant. You need these because not all objects know their own names, and procedures certainly don’t. Use the

The java.net.URLDecoder class has a static method to perform this decoding. The following code fragment resides in the doGet() or doPost() method of a servlet. The variable request is a

The same code can be used for debugging either in development or in production environments. To do so include the following subroutine in the module: Private Sub ShowMessage(msg As String)

This tip is useful for when you are going to make software with a huge facility in which users will have rights to create their own database fields. When a

To determine whether a number is divisible by some even number you have to use the Mod operator in VB. The following code is an alternate, faster way of doing

A protected feature of a class is available to all classes in the same package, just like a friendly feature. Moreover, a protected feature is available to all subclasses of

To specify an expiration time, you can use the setMaxTime(int) method of javax.servlet.http.Cookie. It takes as a parameter the number of seconds before the cookie will expire. For example, for

When a socket wishes to terminate a connection it can linger, allowing unsent data to be transmitted, or it can

The static initialization order disaster is a very subtle and commonly misunderstood aspect of C++. Unfortunately, it’s very hard to detect?the errors occur before main() begins. This means as soon

This can be done for classes derived from CObject through a functionality provided by the MFC as a macro named RUNTIME_CLASS.1. Make a class derived from CObject and create its

The following macros will facilitate this task and have been very useful: #define SAFEDELETE(p) if(p) { delete p; p =NULL;}#define SAFEDELETE_ARRAY if(p) { delete [] p; p = NULL;}How to

Always put the constant on the left side of an equality/inequality comparison like this: if (0 == Value) This is a good practice because if you accidentally put the ‘=’

Calling exit() from any where in the program will result in the process getting terminated. For example, if exit() is called from a code in a dll which is loaded

The size of the int, char, long, or short depends on what operating system and compiler version you are using. The same applies for short and long data types.The usual

You can put VB’s registry functions to good use by creating a few reusable routines that save, reload, and delete size and state of a form in your program. ‘