Tip Bank

Question: [Joe Celko’s Hotel Rooms Puzzle]Ron Hiner put this question on the Watcom forum on CompuServe. He had a data conversion project where he needed to automatically assign some values

Question: What are the key features of Sun’s HoloWeb? Answer: Sun Laboratory’s HoloWeb proposal uses Java as an integrated real-time 3D animation scripting language. HoloWeb is a binary file format,

Question: I am trying to select data from three columns of a table listing all tables of a database. The table_name column is repeated with each separate column_namecolumn, hence the

Question: Which rendering engines are used in VRML browsers and how do they affect my choice of browser? Answer: The library of functions that is used to create all the

Question: [Joe Celko’s Magazine Sales Puzzle]This one was posted on the Sybase forum of CompuServe by Keith McGregor in November of 1994.One of his end users came to him with

Question: How can I ignore case when trying to SELECT allrecords that are LIKE a certain string variable? I have an employee’s name field in which the charactersare a combination

Question: I have a table with three columns: the firstcontains the name of the currency, thesecond contains the currency rate and the third contains the actual date when thecurrency rate

Question: [Joe Celko’s Tax Problem Puzzle]I got this one from Richard S. Romley, via CompuServe. We were engaged in a debate about Sybase’s old T-SQL versus ANSI/ISO SQL-92. I assume

Question: [Joe Celko’s Pension Plan Puzzle]Luke Tymowski, a Canadian programmer, posted an interesting problem on the MSAccess forum on CompuServe in 1994 November. He was working on a pension fund