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

When you create an HTML frameset using the FRAMEBORDER=”0″ attribute, the frames look fine in Internet Explorer. However, there’s an unsightly white gap between non-white pages when you view the

Question: I have an application in which I have to enter employee info and save their photo. I can do that if I use a data control and bound control

Question: I have written an application using VB6/Access. I use DAO. How easy is it to convert the application from Access to SQL Server? Should I make a lot of

Question: I need to compare two object instances of the same class. But I need to compare the contents and not the references (ie: “obj1 is obj2” – will not

Question: Let me describe the problem first: I have a TYPE statement with two variables(appname & dbname). They both are pointing to a global variable that sets the maximum length

Question: How can I put a column from my database into a listbox using VB 6.0? Answer: Here’s a quick way to load a listbox using ADO in VB 6.0.

Question: After retrieving a resultset, using VB6, from SQL Server, I am easily able to populate a grid by setting the resultset to the grid (i.e. Set DataCombo1.DataSource = GetRs).