August 8, 2000

Escaped Characters

Question: When defining a string, is there a way to include a carriage return in the text? Answer: Yes. A carriage return is represented by the special escapedcharacter . However,

ALTER TABLE Command

Question: I’ve archived/purged a few thousand rows of unnecessary data, but the disk space reading hasn’t changed. Do I need to use the ALTER TABLE command to reclaim empty space

System.exit(0)

Question: Most GUI examples show System.exit(0) as the window closing eventhandler. However, System.exit(0) is a bad way to exit applications.The specification says that the VM will exit when all the

Software Required to Make ASPs

Question: Which software is required for Active Server Pages development? Answer: Internet Information Server (IIS) is the most common way to implement ASP, but there are other plug-ins available for

Listing Available Tables

Question: How do I list the available tables in a database I’m querying? Answer: You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like

Return ID in Same Query as Insert

Question: How do I write a query that does an insert and returns the newly assigned ID from that field, all at one time? Answer: The @@IDENTITY variable returns the

RecordCount Property-ADO

Question: How do I get the rowseffected from the execute method of an ADO command object?The code I’ve written is: Dim Cn as New ADODB.ConnectionDim Cmd as New ADODB.CommandDim Recordset

Distribution List E-mail Stuck in Outbox

Question: When I try to send e-mail to the distribution list, it gets stuck in outbox. What should I do? Answer: I’d start by verifying that all of the addresses

Counting Duplicate Rows

Question: How do I count the number of duplicate items in a table? Answer: Lets break down your question into several steps.First, let’s create a sample table using the following