Question: If my SQL Server has the following specs: 6.05.02 SQL-DMO6.50.252 DB-Library Which version do I have? And which service pack version do I have? Answer: If you want to

Question: I’m trying to retrieve the “firstname” and “lastname” fields from a SQL Server database, place them into a column called “fullname” using the AS statement. When I simply retrieve

Question: I would like to build a stored procedure that will receive a table name as a parameter. It then will select the data I want into whatever table name

Question: How do I send an e-mail to myself if a field reads “SEND_MAIL?” For example, a user wants more info on a product, so he clicks on the Send

Question: How do I create a new table? Answer: The DLL syntax for creating a table intuitively is the CREATE TABLE command. You can specify all the options for the

Question: I noticed that MSDN contains sp_OAStop, which shuts down the OLE environment that starts inside SQL Server the first time you call sp_OACreate. But I can’t figure out what

Question: How do I compare two values when one value(data type) is char and the other is an integer? Answer: For this you can use the CONVERT function. Since you

Question: I keep getting a syntax error on the last part of this statement: “SELECT DISTINCT [Company Name], [Street Address] FROM ” & d & ” WHERE[Street Address] !=” Maybe

Question: How do I get the average of three columns for each row of a table that has four columns of information? Answer: Let’s say you have a table called

At times you may need to access the command line passed to the application from within an ActiveX DLL. Unfortunately, when inside a DLL the Command$ function returns a null

By defining a Public Enum and using it as a parameter type to yourproperty or function, client applications are presented with a drop down list of values to use. Unfortunately,

By default IIS 4 doesn’t permit to use the Server.CreateObject command with an out-process ActiveX EXE component. To do so, you must manually create the AllowOutOfProcCmpts registry value under the

When you pass a non-existing key to the WriteProperty method of the PropertyBag object you get an error 327 “Data value named ‘namekey‘ not found”. This is more or less

While determine whether the current program is running as interpreted or compiled code is relatively easy, determine whether an ActiveX DLL is serving an interpreted or compiled application is a

As explained elsewhere in this knowledge base, you are suggested not to rely on the OnStartPage method to get a reference to the main ASP objects, if your component is

Before going to production, you should ensure that the server-side script debugging is off for your ASP application. In fact, not only does server-side debugging slow down your application, it

When an interpreted client running in the IDE enters debug (break) mode, all the ActiveX DLL it’s using continue to be in run mode as usual, even though you won’t

Postfix operators, namely ++ and –, are less efficient than their prefix counterparts because the compiler usually creates a temporary copy of the object before applying the operator to an

Many programmers still use the non-standard, platform dependent BOOL typedef instead of using bool. There are many good reasons why you shouldn’t use BOOL; one of them has to do

In several occasions, C++ requires the use of integral constant expressions, for instance: array bounds, case expressions, bit-field lengths, and enumerator initializers must all be integral constant expressions. An integral

Another set of typedef names for integer types defined in < inttypes.h > is called “fastest minimum-width integer types.” Each of these typedef names designates aninteger type that is usually

The newly approved C99 standard defines a new header file called < inttypes.h >, which defines sets of typedef names for integer types. One of these sets defines integer types

Question: How do I dynamically convert HTML to WML? I would like to take data from, say, a stock-quote page, strip it, and display the info in WML. Answer: Some

Question: Can the ORACLE database talk with XML like SQL Server can? Answer: An XML parser is available in Oracle8i. Oracle is developing a product called Messenger that will allow

Question: Can I send an e-mail via WAP, handheld PC or other units when I’m on the go? Answer: There are lots of possibilities. You can set up a WML/ASP