Question: [Joe Celko’s Work Order Puzzle]Cenk Ersoy asked this question on the Gupta Forum on CompuServe. He has a table that looks like this: CREATE TABLE Projects (workorder CHAR(5) NOT
Question: What is the best Netscape plug-in for viewing VRML files? Answer: I assume that because Netscape has chosen Live3d, formerly the WebFX browser from Paper Software, to be the
Question: Is there a site where VRML is being used to display information in a unique way? Answer: Yes, the most innovative site I have come across is that of
Question: I have a table that consists of numbers stored as characters.How can I sort them in numerical order? I can’t convert thisfield to numeric because some content is alpha
Question: [Joe Celko’s Reservations Puzzle]Since I spend a lot of time this column talking about problems with the order of execution of SQL statements, it is only fair that I
Question: [Joe Celko’s Sales Gaps Puzzle]Given a table “sales” and a column “saledate” and “customer,” is there a way to get the average number of days between sales dates for
Question: Is it possible to set indexes between tables in SQL expression? Answer: You can establish indexes on SQL tables, but SQL indexes do not create an implied relationship between
Question: Are wildcards allowed when trying to matchthe contents of a textfield as in the following example? SELECT * FROM Database WHERE textfield = ‘B*’ Answer: Yes, but you’ll need
Question: [Joe Celko’s Quantity on Hand Puzzle]You are now the guy in charge of the company inventory. You get requisitions that tell how many widgets people are putting into a