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

Modifying Windows NT’s registry entry can change default scripting language for ASP at the server level. Changing the default at the server level affects all applications that run on the

Question: I was out on the Fox newsgroup and somebody posted some ADO code in Visual FoxPro that alarmed me. VFP seems to have a major problem repeatedly accessing the

Question: I am a technical copywriter currently writing a fact sheet for a software company providing DB2 SQL support. They have something they want to call “limited dynamic SQL.” Here’s

Question: I have a problem comparing columns from different tables. I tried: SELECT tblThumBereinigt.Nummer, dbo_BABEWERTUNG.BANUMMERFROM dbo_BABEWERTUNG, tblThumBereinigtWHERE (((dbo_BABEWERTUNG.BANUMMER)[tblThumBereinigt].[Nummer])); but this does not give me what I want. How can I

Question: How difficult is it to convert a Sybase Transact-SQL database to SQL/400, and where can I find information on SQL/400? Answer: I don’t know but, in the main, learning

Question: How do I correct a spelling error in a table? I am at a loss as to where to start. Answer: Hoping for the best, I’d say that what