Question: In the WHERE condition, I have not been able to use the AND condition when the two conditions on either side of the AND command relate to data the

Question: I have accidentally deleted the ‘From’ column from my inbox. Could you instruct me how to get this column back? Answer: Right-click the header of any other column (like

Question: How do I host another domain into a single server if it has a different DNS server than mine? I have my DNS from a local ISP; the other

Question: I have a lone Macintosh user among an office of Windows users. This user has Outlook 8.2 running, with all mailboxes stored on the server. Understandably this is quite

The standard way to delete all the rows in a SQL Server table is a DELETE statement without a WHERE clause:DELETE FROM MyTable However, in most cases you can speed

The built-in ++ and?operators can appear on both sides of their operand: int n=0;++n; // prefix ++n++; // postfix ++ You probably know that a prefix operator first changes its

You can allocate a multidimensional array using new as follows: class A{public: int j;//…constructor, destructor, etc.}void func(){ int m; A (*pa)[2][2]=new A[2][2][2]; // three dimensional array m=pa[0][0][0].j; // access member

Novices, especially those who have experience with garbage-collected languages, are often confused with the concept of object deallocation and destruction in C++. They tend to explicitly invoke every object’s destructor

A definition of namespace alias can be used to redefine a previously defined namespace alias declared in that scope, as long as the new definition refers only to the same

Question: How do you integrate an ad-serving technology (such as one by Doubleclick that enables you to rotate ads on a regular Web page) onto a cell phone or PDA?

Question: Is the IIF function valid under SQL server 7.0? It’s in the SQL Books Online as valid, but none of my stored procedures accept it. Answer: The IIF function

String in Java is a constant object, which means by default it can becreated and read but not modified. Usually developers use the Stringextensively but forget the overhead it may

Many programmers believe that by storing pointers instead of objects in a container, they improve performance. However, they forget that the pointers still refer to existing objects that must be

The stack is a region of memory on which local automatic variables are created and function arguments are passed. The implementation allocates a default stack size per process. On modern

Consider the following two classes: class A{private: int n;public: int m;};class B{private: int n; int m;}; Theoretically, the memory layout of these two classes may be different because A has

To block a class from being derived any further, declare its constructor private. Next, add a public static member function Instance() that creates an instance of this class and returns

When you declare a nested class as a friend of its containing class, place the friend declaration after the declaration of the nested class, not before: class A // containing

Question: I’m trying to install a search facility on a database program I have written using VB6 and an Access database. I’ve opened by inserting a data control onto my

Question: I’d like to know how can I make a return of a function’s local variable (for example, a reference to it) not using pointers technique? Answer: You have tow

Question: I am getting a compile error ‘huge’ obsolete keyword. I am converting a process from Visual C++ 2.0 to 6.0. What keyword could I use in place of ‘huge’?

Question: How can I dynamically build a procedure call string and then get it to execute? Ex. Dim action as String action = “proc(param1,param2)” call action I know this does

Question: In MFC, what does the following declaration do? CPen::operator HPEN() const; My understanding of the operator keyword is that you cannot use it to create a new operator; however,

When working with a forward-only, read-only Recordset – that is, the default ADO Recordset – the RecordCount property always returns -1. (This can also happen with other types of server-side

Suppose you have two tables named Table1 and Table2 with one or more fields named the same way. Now, consider this query: rs.Open “SELECT * FROM table1 INNER JOIN table2

The syntax for opening a password-protected Jet database might not be obvious. In fact, assigning the password to the Password property in the ConnectionString raises the following error: Run-time Error: