Question: If I just want to see some data from a table, is there some SQL syntax to prevent 2 million rows from coming back without adding conditions on the

Question: Could you please give me a simple explanation to what stacks are? How do they work and what are their related features? Answer: Stacks are temporary resting places for

Question: I have a table below: Name idJohn 40Mary 50Peter 15John 40Peter 15John 40 How can I query to get who appeared most of the times in the table? (In

Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the

Question: I am writing a Visual Basic app that is all about a database created in Access 97 with about 500 records. I want to be able to filter things,

Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs

Question: Microsoft naming conventions for Visual Basic (Hungarian notation) is well documented and widely used. Is there a similar/well-known standard for variables used in SQL Server stored procedures? Answer: Not

Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system

Question: I have a statement to submit a form: This JavaScript will validate entries in different textboxes placed on the form: FormCheck(this.form, ”, ”) When the user clicks the enter

Question: I recently bought a book that includes the XML specification as well as some commentary. Much to my surprise, I found that after authoring an XML document, the browser

Question: Does using the recordset.filter variable slow down response time greatly? For example: rsObj.filter = “sCat = 1” I am using it to filter my recordset object so that I

You can increase the speed of download by reducing the number of bits each page needs to be displayed. One way to shrink the download size is to reuse components

ASP strips out white space between the closing delimiter of a statement and the opening delimiter of the following statement. If there is a need to preserve the white space

If an IIS application needs to rely on the session state, then you should try to avoid putting large data in the session object and session states. Session tracking maintains

The Java servlet below demonstrates how to use compressed output fromservlets. You can compress big chunks of data before sending and they will be decompressed on the fly in the

To debug an MTS component in Visual Basic 6.0, make sure that the MTSTransactionMode property on MTS Objects (VB 6.0 Classes) is set to a value other than 0-NotAnMtsObject. When

Some classes in the Standard Library do not have a virtual destructor or virtual member functions by design. These classes include std::string, std::complex, and all STL containers. The lack of

When trying to navigate through a complex class hierarchy from any given instance of an object, it’s useful to be able to reference its parent. But how do you clean

Many applications have an option to show the toolbars as text and image or text-only. I have seen programmers handle this with two toolbars and show them based on the

Passing a derived object by value to a function that takes a base object by value may cause a problem known as “object slicing”; every additional data member declared in

You can protect the server from a crashing application by running the Web applications in their own memory space. To configure IIS to do this, launch the Internet Service Manager

This little routine demonstrates how easily you can determine the number of substrings within a string, given any specified separator character(s). Pass the string to be parsed, and the separator,

Sometimes, you need to force an object to destroy itself because its destructor performs an operation needed immediately. For example, when you want to release a mutex or close a

hen using a class that implements an interface, it can be frustrating to have to create two variables to reference all the properties of both the interface class and the

In small projects I am involved with, I frequently access project-related INI files and help files. At times I work with identical databases on Access and SQL Server, so I

In addition to the traditional macros __DATE__, __LINE__, and __FILE__, which are defined by ANSI C, the new C9X Draft Standard also defines the macro __FUNCTION__. __FUNCTION__ is expanded as

You can improve performance of ASP pages by putting HTML and script in separate blocks on the Web page. In other words, you should avoid interspersing the script code throughout

Another frequently asked question in C++ newsgroups: “Is there a tool that decompiles an executable program back into C++ source code?” The short answer is “no, there isn’t”. The longer

Sometimes, you need to force an object to destroy itself because its destructor performs an operation needed immediately. For example, when you want to release a mutex or close a

Programmers often need to know whether only a part of a window is visible. This can require a difficult calculation with coordinates. Use this routine to easily determine the visible