









Adding Records to a Table in an SQL Database
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: 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