









Comparing Values in a Table Against Current Time
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: 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: 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: In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing
Question: I have a Visual Basic project about a video store, for which I have to produce a report that includes the following: Top 10 movies last month Number of
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: 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: 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: 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: Could you please give me a simple explanation to what stacks are? How do they work and what are their related features? Answer: Stacks are temporary resting places for