Question: How do I count the records for a specific field? For example, I’m building a table for homes in a county. In the table are fields for cities and

Question: How do I use the Group By statement in SQL Query? Answer: Group By is a way to collapse a result set around a textual value summarizing its contents

Question: I want to set up a hot backup between two SQL servers on two different NT machines. In other words, if one of these servers goes down I want

Question: Could you please explain how to trap the e-mail ID from the In-box, so that I can filter my incoming junk mails? Answer: Filtering junk mail is tricky business

Question: Why do Journal entries within a (slightly) customized contacts database in Public folders only appear to the user who logged the Journal entry? All other fields in the contact

Question: I need to have a result from a SELECT query with all the rows containing “word1” in column 1 and all the rows containing “word2” in column 2. If

Private Declare Function GetShortPathName Lib “kernel32” Alias _ “GetShortPathNameA” (ByVal lpszLongPath As String, _ ByVal lpszShortPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a long

You need just one-line function to evaluate the number of days in a month (while taking leap years into account, of course). The trick is to use the DateDiff and

The DatePart() function can return the number of days from the beginning of the current year, but there is no VB built-in function that returns the number of days left

Private Declare Function GetLongPathName Lib “kernel32” Alias _ “GetLongPathNameA” (ByVal lpszShortPath As String, _ ByVal lpszLongPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a short

‘ convert a date value into a string in the format’ YY years, MM months, DD days, HH hours, MM minutes, SS.HH seconds)’ you can also opt for time short

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =

Question: How can I get the number of records returned by a query without cycling through all the records and counting each one? Answer: Have you tried SELECT COUNT(*) FROM

Question: How can I get Exchange to forward e-mail to an AOL or ATT account automatically? We have traveling users who have AOL or ATT accounts and would like all

Question: I am a student. Is there a way to load a database into Oracle to run my exercises? Answer: I’m not sure I can help you because there’s more

Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person

Question: I have upgraded from Outlook Express to Outlook 98. Previously I was able to leave messages to a particular e-mail recipient on the server. With Outlook 98 I no

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

Question: I have a SQL database on our production NT server and need to move the database to another NT server. I used the Database/object transfer in Enterprise Manager to

Question: I am with a large Fortune 500 company looking for a training management solution to produce CBT courses, organize, and report on skill-based courses and instructor-led courses on our

Question: I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database? Also, is there

Question: What is the difference between two dates, date1 and date2, when date2 is in the next record? Answer: Use this code: select datediff(laterone.date1, earlierone.date1) from table earlierone, table lateronewhere

Question: From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF. How can I insert this file in my current SQL Server 7.0? Answer: Here are

You can improve performance of your ADO applications by properly selecting the Cursor and Lock Types while opening the recordsets. Cursor Type indicates the type of the cursor the provider

You can use Clone() method of ADODB.Recordset object to create a duplicate recordset object from an existing recordset object. An important advantage of this method is that instead of creating

You can initialize variables of fundamental types by invoking their constructor: int n = int(); /* zero initialized */ char c = char(); /* ditto */ short *ps = new

As ASP programmers, we use the Request variable to retrieve information from our Web users. In a previous Web tip I showed how we could extract the values from a