When running action queries make sure you add the adExecuteNoRecords option, so that a recordset is not created. You can also use this technique in lookup situations when returning just

When using the SSTab control to build a tabbed dialog, I often find the design more pleasing when the OK/Cancel buttons or other controls appear on every tab. It Related

This script can be used in ASP or VBScript or Visual Basic. It is an easy way to create a folder tree. Sub CreateFolderTree(ByVal FolderName) Dim objFSO Dim InterminPath Dim

The following subroutine requires two parameters1) Recordset2) Count of records per page. For example: Call EasyPaging(Rs,10)

Assume that you have a set of classes that need to provide the same functionality but the way they provide it is different. In essence, these are the classes that

The GO Command sends the current batch of Transact-SQL statements to SQL Server as a batch. The current batch of statements is composed of all those statements entered since the

You can control the concatenation results using SQL ServerCONCAT_NULL_YIELDS_NULL(T-SQL). Depending upon the CONCAT_NULL_YIELDS_NULL settings, the concatenation results are treated as null or empty string values. When SET CONCAT_NULL_YIELDS_NULL is ON,

The compiler reports an error if you try to compile a piece of code like the one follows: int x = 9;switch(x){ case 1: int i = 0; break; case

Sprinkling TRACE statements in your code is a common practice during development and debugging, especially when refereshing UI code, or multi-threading, etc.Usually, people write something like this: TRACE(“My Trace “);

Conditional typedef declarations can be useful in cross-platform development. For example, some platforms define long as a 32-bit integer. Other platforms treat long as a 64-bit integer. You can create

As strange as it may seem, C++ doesn’t allow you to re-open a namespace using a qualified name; you can re-open it only by using its nested name. For example,

One of the most overlooked and underused methods of the ADO object is GetRows(). This will quickly retrieve your recordset as a bi-dimensional array in the form of Array(columns,rows). While

Define value: Combine with the xml file: Use it: The value define statement can be created in an xsl file, and this file can be included in other xsl files

JavaScript lacks a Replace() function. This functionality can only be achieved in Javascript using RegularExpression, though not all browsers support it. The code below is for replace and can work

Although most people have JavaScript enabled on their browsers, there are still a lot of people who don’t. This is why you should always make your pages as backward compatible

This code will retrieve the employee details with a salary-wise ranking from each dept.EMP table with different departments and different salaries. If two employees in the same department have the

Sometimes you may want to check whether a particular file is available while working with the file system in T-SQL. You can check this by using “xp_fileexist “, Sql Server

COM doesn’t have a built in security mechanism, but relies on Windows authentication services (Security Service Providers). When you access a resource or invoke a method in a remote DCOM

CreateInstance was necessary in COM to provide a COM object activation mechanism that could be hooked by the MTS runtime before the activation request reached the COM runtime. So that

There is quite a lot of misunderstanding among COM newbies about what really happens when a COM interface is passed as a method parameter. As in most of the cases,

What I describe for COM+, applies to MTS with some slight differences as well. Registering COM objects remotely has been quite a pain before MTS showed up (remember the VBR

Among the different COM details that VB hides to the programmers, one of the most problematic one is that it doesn’t let you take control on interface GUIDs. Binary compatibility

If you don’t take specific actions, you get an Access Denied Error when you try to raise an event from an MTS component into a client. This happens because the

Suppose you have a table: select * from tblTestName Amount— ——A 10B 20c 40D 50E 30 The following single SELECT query can be used to calculate cumulative totals: –//////////////////////////////////////SELECT t1.Name,

There may be certain situations where you have to sort character-based columns in a particular order.For example, Let us consider a table: –///////////////////////////////////SID Subject Marks— —— —–1 Physics 801 Chemistry

The following code is bad: char* charpointer= new char[SOMECONSTANT];delete charpointer; // should have been delete [] charpointer; new and new[] are allowed to use different memory pools. The default new/delete

The most common example where ‘open’ date is used is in the expiration_date for an entry. It could be set for a particular date, or be NULL if the expiration