March 24, 1997

Question: How do I create a column with a row ID that adjusts if a row is deleted?That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record

Question: I’ve been trying to construct a query on the databaseto see if the value in a particular field matches a long list of correct answers. For example, I would

Question: I have an employee table with a field empno (employee number) and an hours table that contains all time that is worked by all employees.The hours table has the

Question: I have two related tables. I need to go and update atable searching for a value I find in the second table (byjoining both tables). I wrote the following

Question: [Joe Celko’s Equal Sets Puzzle]Set theory has two symbols for subsets. One is a “horseshoe” on its side, which means that set A is contained within set B and

Question: I want to periodically check to see if a user’s database connection has been lost. How can I? Answer: First of all, a solution. You can implement periodic ‘polling’

Question: What are the advantages/disadvantages of putting large binary files (1+ MB) in BLOB columns versus storing them on a file server with a reference such as a directory/file spec

Question: I have nine offices. I want each office to connect across aWAN and run client/server applications with all datacontained on one central server. However, we are finding the delays

Question: What are the differences between LEFT, RIGHT, INNER and OUTER JOINS? Answer: An INNER JOIN is the most common type: It combines all the data from the tables specified