Tip Bank

Question: I am using Exchange Server 5.5 and Outlook 97 on about 30 workstations. I use a public folder to store shared contact info. On all but two of the

Question: If I just want to see some data from a table, is there some SQL syntax to prevent 2 million rows from coming back without adding conditions on the

Question: I’m having a problem writing a SELECT statement that will compares a date stored in a table against the current time. This is for a calendar on a Web

Question: How do you list available tables and their schemas from an SQL query? Answer: There is an owner in the database called INFORMATION_SCHEMA who has a bunch of objects

Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system

Question: How do I convert a character string into a time field? Data is being read in as 12:10 and I need to calculate response times based on this field.

Question: I have a Web page that lets the user query my database and return results in groups of 50 records. I know how to do the first SQL statement

Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the

Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs