Question: Can the latest version of ADO (ActiveX Data Objects) read and write an XML file as a recordset? Answer: Ah, let me qualify that: ADO 2.1 can currently produce

Question: How can I modify and update XML docs that are stored in the cache using a DCOM model (client side)? Answer: Given that caching is an IIS (Internet Information

Question: How do I truncate the last five characters in a field? (The string length varies from row to row.) Answer: Try something along these lines: select left(myfield, datalength(myfield)-5)

Question: How do I force a linefeed character using SQL? I created a report (see below) but when I e-mailed this report from Unix the carriage return was not interpreted

Question: I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact

Question: Does XML work with VBA (Visual Basic for Applications)? I’m looking for a quick and easy way to store variable information that will be static once it has been

Question: I want to convert a signed integer into a 16-bit binary as part of a SELECT statement. For example: select myint, howeveritsdone as Binaryfrom mytablemyint Binary—- —————–137 1111111101110111-100 1111111110011100

Question: I want to add two numeric fields with values like these: Example 1: One field named Amount contains 565.25 and other field named Ticket contains null. select amount +

Question: How can I create a crosstab in SQL Server 7.0? I’m used to Microsoft Access, where I can use columnheading and rowheading. Does this work in SQL? Answer: This

Question: I have two tables and both tables have a one-to-many relationship. I want to add a new single record in the first “transheader” table (key is autonumber) and get

Question: How do I extract dates from SQL where the date type is a datetimestamp? I have the following SQL statement: select * from Patient where PatientDOB = “03/01/58” It

When the Visual InterDev Scripting Object Model (SOM) creates an option group object (a set of radio buttons), it selects the first radio button when the page loads. You may

If you need to calculate a time difference between your Web server and visitors to your site, look into the JavaScript getTimezoneOffset() method. It returns the time zone difference in

Question: I have WinNT4.0, Service Pack 5.0 SQL Server7.0, ODBC Driver for SQL 3.70.06.23. I have a servlet program that connects to a JDBC-ODBC bridge and accesses the database. If

Question: I am running SQL Server 7.0 with 20 user licenses. I have about 40 users, of which only 10 are logged on at once. The problem I am running

Question: When I try to import data to SQL, I find a problem in exporting the date values that occur earlier than the year 1752. Since I am working in

Question: I own a company and have two database servers. One is MS SQL6.5 and the other is a Sybase server. I want to access both servers on a client

Question: My question is simple, yet I can’t seem to find any help on it. I cannot add records to any of the tables in my SQL database. All the

Question: We currently have two contact databases in ACT. One of them is growing exponentially and at 70,000 records we are already experiencing problems. We are considering switching to MS

Question: I have two fields in my query: SELECT minutes, cost FROM SomeTable However, I would like to calculate the cost/minutes for each row selected. So I tried the following:

Question: We use Dunn & Bradstreet’s Smart Streem System with a subledger that has a high volume of data, and as of this point has to be identified manually and

Question: If a table has a primary key on columns A, B, and C, is there any advantage to also defining an index on columns A and B? Wouldn’t the

Question: I need a text (or char) field that can hold more than 255 characters. Something like a Memo field to hold almost unlimited character data. Is this possible? Answer:

Question: I am developing an application package with VB 6.0 and SQL Server 7.0. My problem is that I can add new records to the ADO recordset but I am

Question: Once a table has been created, is there any way of deleting it in SQL? Answer: Try: DROP TableName

Question: I have two tables: Yarn {Y_yarn_code,x_code}y_yarn_code being PK Yarn_lot (yl_yarn_code) I need to update yl_yarn_code with x_code where y_yarn-code=yl_yarn_code Answer: Try this: UPDATE Yarn_Lot SET Yarn_Lot.yl_yarn_code = (SELECT x_code

Question: I am converting a database from Access to SQL. It is a large database?some 4.5GB large. I get a timeout (1 minute) before I get my response back. Can

Question: Is there a way to use an INSERT statement inside of a view? If it is not possible through a view, how do I use an INSERT statement? I

Question: As a novice SQL Loader user, I have imported a comma-delimited ASCII file into an Oracle database (Unix) using >sqlldr and specifying the delimiter as a comma. I now

The FileSystemObject object (sic) in Active Server Pages (ASP) is very handy for reading, writing, and deleting files via server-side script. However, it isn’t always easy to locate your files