You can change the given format into the required date format using the CONVERT Function. Here’s an example: companyid peo———– ———–104 1998-09-30104 1999-09-30104 1999-12-31104 2000-03-31104 2000-06-30104 2000-09-30104 2000-12-31104 2001-03-31104 2001-06-30104

It’s possible to send messages from one system to another system in an Intranet by using ‘xp_cmdshell’ extended stored procedure in MS SQL Server. The usage of this procedure can

A string contains Yes or No answers to a series questions. How do you count the number of correct answers and wrong answers?Here’s the code: DECLARE @TestResults varchar (120)SET @TestResults

public String toString(){ StringBuffer sb = new StringBuffer( 256 ); sb.append(“[Field Name] [Value] “); Class curr = this.getClass(); while(curr != null){ Field[] field = curr.getDeclaredFields(); for(int i=0; i

The basic difference between the “==” and the “equals” method is to compare the two entities on either side of the operator or the method. But when objects are compared,

Oftentimes, you hard code values like URL

If you use OR against a table when you are trying to retrieve rows on matching criteria, it will search the table as many times as matching criteria you gave.

JBuilder’s templates allow you to insert some of the most common Java instructions into the editor. For instance, suppose you want to add a main method to a class. Instead

It’s possible to use the dir() and the dir$() functions to list directories. However, many programmers handle the two first returns from the functions “.” and “..” by using an

To reduce the number of fraction digits in a double type variable, follow the code sample below. This can be useful in money calculations. Firstly, create a NumberFormat instance and

It is possible to sort any type of array of elements, even if you don’t know a sorting algorithm. First, pass an array variable to sort the method (which is

When exception specifications were added to C++ a few years ago, they looked very promising. However, as is often the case in a programming language

When multiple base classes have members with identical names, this can lead to ambiguities in the derived class, even if the signatures of the member functions in question are distinct.

In the following example, a member initialization list appears in the inline definition of the constructor, inside the class body: class ratio {private: int x, y;public: ratio(int top, int bot)

You can press Ctrl-Spacebar to make IntelliSense prompt you for variables, methods, properties, or events at any point in a code window.For example, if you have a variable named myvariable,

This function removes attributes from files in the folder you specify in strFolder. It also can walk down all subfolders of this folder recursively. This function was written mainly for

It’s common VB knowledge that you can omit the default property of a control or an object. For example, statements such as Text1.Text = “blah” and Text1 = “blah” are

If you

Database applications often need to forbid user input to combo boxes, which limits the user to a given set of choices. But just as often, these apps need to assign

If the LINK environment variable is set to /MAP when VB launches, you’ll get a MAP file whenever you Make EXE, even when you are not generating debug symbols. Keeping

I often find it necessary to check that a string is valid by ensuring it exists in a list of strings. For instance, you might need to check that a

Here

In general, disabling inheritance is a dubious idea. Yet under some circumstances it may be useful. To do this, declare the class in question (called A in our example) as

A template

Sometimes you don’t want to enable the option of running more than one instance of an executable at a time. This can be achieved by using this fragment of code:

The algorithms in the standard C++ library are generic and, as such, can be inefficient (or unavailable) with certain containers.For example, the std::swap algorithm is generic but lists define an

C-style arrays can be passed as containers to STL algorithms. The pointers to array elements can be used as iterators.Example: #include #include int main(){ int array[] = { 1, 3,