Tip Bank

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

Question: [Joe Celko’s Phone Book Puzzle]You are trying to set up an office telephone directory and have the following tables: CREATE TABLE Employees (empid INTEGER PRIMARY KEY, firstname CHAR(20) NOT

Question: What are the key features of IBM’s VRML 2.0 proposal? Answer: Researchers at IBM Japan have proposed a reactive virtual environment. No Web references to the proposal were available