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: I want to be able to take an action when a user changes the value of a data field, but not when the value of the field is changed
Question: Our business is just starting to look at using a relational databasemanagement system. We are currently using computers, but the usershave their own copies of whatever data they need
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
Question: When a user selects a value from a list box, I populate the contents of arepeater. I also want to set the focus into the repeater’s first field.How can