While SQL Server uses 2049 as the cutoff year for interpreting dates, OLE Automation objects use the year 2030. To provide consistency in date values between SQL Server and client

In ASP, pairs are used to indicate a server-side script. It is a good idea to put this pair on the same line whenever possible. Because the ASP engine reads

Because the ASP engine reads and interprets every character in the file, adding comments in the ASP page increases the work of the IIS. Although the HTML page that is

It is a good idea to build a separate error-handling ASP page and call it from the code whenever it is required. Besides being a modular approach, it also improves

A common user scenario in a development environment is where the code typically opens a connection, executes a row or non-row returning command, processes results, and closes the connection. For

The File DSN usage should be avoided whenever possible. Instead, use System DSN; it is, on average, twice as fast. Also, File DSN is less secure because the database name,

SQL Trace can monitor, filter, and record all of the calls sent from the client applications to the server. It often reveals unexpected application overhead due to unnecessary calls to

RDO is an object interface that is closely tied to ODBC and is optimized for accessing SQL Server databases, especially from Visual Basic programs. It has little performance overhead on

ADO 2.0 includes few optimizations when it is marked as an Apartment model in the Registry. It determines the threading model from the Registry at DLL load time. The scaling

Question: How do I find out the top-five best sale items? I want the maximum five items to be listed. Answer: In version 7, SQL Server has conveniently provided the

Question: What is faster: two LIKE statements or one BETWEEN? ((MyData LIKE ‘02105_’) OR ((MyData LIKE ‘02106_)MyData BETWEEN ‘021050’ AND ‘021069’ Please advise. Answer: When trying to decide which is

You can access all variables directly by calling Request(variable) without the collection name. In this case, the Web server searches the collections in this order: QueryString Form Cookies ClientCertificate ServerVariables

Question: I have installed Windows 2000 on my laptop. I would like to create an emergency start disk akin to Windows 98. My current partition is FAT32. I created a

Question: Does Microsoft plan on implementing dual processor support in Windows “Millenium” and will it be based on NT? I’m just trying to decide whether I should upgrade my Win98

Question: I have two PCs at home which are used by various members of my family. I want to connect them as a small network. Can I do this by

Question: I need to schedule a batch file to automatically run at night. I have tried every variation of the “AT” command from a command line on the Windows NT

Question: I would like to know for containment (having objects as data member), what is meant by “if the inner class object’s constructor requires parameters, the initialization syntax must be

Question: I have 20 predefined strings that I want to put into an array of strings. Here is my idea: #include static std::string array[20]; If I do just this, I

Question: I am not sure if it is good when I use the assert macro in the following code: int sum(int number)// Precondition: number => 1// Postcondition: return sum from

‘ return a file path not longer than the number of character’ specified in the 2nd argument” If necessary, it replaces directory names with ellipsises” Author: Fred Block’ CuzWare Systems’

Private Type POINTAPI x As Long Y As LongEnd TypePrivate Declare Function SetPixel& Lib “gdi32” (ByVal hDC As Long, _ ByVal x As Long, ByVal Y As Long, ByVal crColor

‘ —————————————-‘ The Rotator class module” A class for printing rotated text to a ‘ Form, PictureBox or the Printer” Author: Timm Dickel ([email protected])” —————————————-‘ Usage:’ Dim rotTest As New

Private Declare Function OemKeyScan Lib “user32” (ByVal wOemChar As Integer) As _ LongPrivate Declare Function CharToOem Lib “user32” Alias “CharToOemA” (ByVal _ lpszSrc As String, ByVal lpszDst As String) As

Option Explicit’————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1

Private Type OSVERSIONINFO dwOSVersionInfoSize As Long dwMajorVersion As Long dwMinorVersion As Long dwBuildNumber As Long dwPlatformId As Long szCSDVersion As String * 128End TypePrivate Declare Function GetVersionEx Lib “kernel32” Alias

‘————————————————————————‘ This enum is used by both InstrWordEx and ReplaceWordEx” It uses a binary value to determine what separator characters are allowed’ bit 0 = allow spaces’ bit 1 =

You should prefer to use the MapPath() method of the Server object instead of hard coding the complete literal paths in ASP applications. The MapPath() method allows you to physically

Question: I’m looking to make an online contact list without creating a whole new ASP page for my company. I was thinking that I could simply put the Outlook contact

Question: I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables

Question: We are sending over 50K of outgoing e-mails an hour. Today the queue fills and we can only handle about 20K an hour. At some point the mail server