BEGIN-END lets you group T-SQL statements and execute multiple statements as a result of a conditional test. This helps in grouping a series of SQL statements so that control-of-flow language,

The term “aggregate” is used in the ANSI standard to denote an array or a class with no constructors, no private or protected data members, no base classes, and no

In C and C++, a union is aligned according to the alignment requirements of its largest member. For example: union U{ char c; short s; int i;}; The union U

Most CPUs require that objects and variables reside at particular offsets in the system’s memory. For example, 32-bit processors require a 4-byte integer to reside at a memory address that

Stringent compilers issue a warning message when a function’s return value is ignored. For example: int func(){ return 0;}int main(){ func(); //return value ignored} Indeed, ignoring a function’s return value

C++ defines textual representations for logical operators. Platforms and hardware equipment that do not support all the special characters used as logical operators can use these alternative representations. The alternative

Use WithEvents to perform an action when you change any font properties of a specific control or form. Make sure you set the OLE Automation reference in the References dialog:

VB has no built-in Sort function. Although lots of sort routines of varying complexity and performance are available, there’s a simple “cheat” that you might find useful. The standard VB

Whenever you want a ListView control with flat, nonclickable headers, use this code to toggle the header style. Flat headers don’t give users the impression of sortability that 3-D headers

A common need in database processing is retrieving a list of the values of a particular column field for every record in a table. This function takes arguments for a

We all know that using global variables in our projects is not considered good programming practice. Nevertheless, everyone does it. Sometimes you need to introduce public variables for storing initialization

Question: How can I speed up the download time of the text and images on my company’s Web site? Is there any rule of thumb to go by? Answer: The

Question: I am trying to insert a record into the database but it doesn’t seem to be working correctly due to the way the database is set up. Deleted HTML

Question: Is it possible for a function to return an array instead of a single value? Answer: No but, then again, you don’t really pass arrays as parameters, either. What

Question: I am using Microsoft Visual C++ 6.0 and am trying to create a callback function pointer to the public member of a class, but I keep getting the following

Question: I am using several large data structures as linked lists to process some data. Many of my helper functions use recursion. Because of the size/amount of data that I’m

Question: Is it possible to find out the last modified date of a Microsoft Word file on a server, through an ASP page? Answer: Yes it is. Use the ‘DateLastModified’

Question: What is the C++ equivalent of the fflush(stdin) statement in C? Answer: Fortunately, although C++ offers many new ways of doing thing, it still includes everything that was in

Question: I’m trying to write an app that handles some complex mathematical functions, but am hitting a wall in regards to the int data type. I need to store and

Question: Is there any way I can use ASP to get the date format on the server? I don’t want to return a date and then print it. I want

Question: Is it possible to create a server-side object so that an ASP page can gain access to Microsoft Office information? I am trying to find a way to edit

Question: How can I display groups of records (for example, the first 10 records), then allow the user to click Next to display the next set of records? I have

Question: I need to put a selected item from a drop-down listbox into a global variable. The listbox is named select1. Here is my code: When I go the next

Question: I have a database hooked up to my Web page. I can do a search and it works fine, but during my search, if I spell a word wrong,

Question: I am trying to access some PDF files in a database. I give the address of the file in the browser as an IP address. I am trying to

Question: I tried loading two frames in the browser called “TOP” and “BOTTOM”. The “BOTTOM” frame loads a JavaScript file (j1.js) and another two frames in it called “LEFT” and

Question: I am using tags as dropdown menus at the top of my pages. But if I have an ActiveX control below my menu then the dropdown menus’ fall drops

Question: Is there any way to retain values in a page (text box, check box, radio, and so on) after going to some other page and coming back? I don’t

Question: I am having a problem accessing the form elements that are inside a DIV tag. It works in Internet Explorer but not in Netscape. The alert comes in both

Question: I need to create a page that will issue a unique authorization number after a customer has filled out a form. I have created a form that writes to