Tip Bank

Question: How do I compare two tables and extract only where field1 doesn’t match field2? Will MINUS do it? Answer: Yes, but it’s not that direct. To do MINUS (or

Question: I have a Microsoft Exchange mailbox and want to have all my e-mail forwarded to a Unix e-mail address. I tried the Forward All Mail feature in Outlook but

Question: Does SQL 7.0 allow you to restore a table from a database dump much the way SQL 6.5 did? Answer: No, not exactly. The only way you can restore

Question: I have a problem comparing columns from different tables. I tried: SELECT tblThumBereinigt.Nummer, dbo_BABEWERTUNG.BANUMMERFROM dbo_BABEWERTUNG, tblThumBereinigtWHERE (((dbo_BABEWERTUNG.BANUMMER)[tblThumBereinigt].[Nummer])); but this does not give me what I want. How can I

Question: Is it possible to create a DTS package that does an Update rather than a Select statement? Also, when I save a DTS package in a file (*.dts as

Question: I populate the list view control with the required items and each of these items are set with a pre-defined structure in the data attribute of the list view

Question: I am a technical copywriter currently writing a fact sheet for a software company providing DB2 SQL support. They have something they want to call “limited dynamic SQL.” Here’s

Question: I was out on the Fox newsgroup and somebody posted some ADO code in Visual FoxPro that alarmed me. VFP seems to have a major problem repeatedly accessing the

Question: How do I correct a spelling error in a table? I am at a loss as to where to start. Answer: Hoping for the best, I’d say that what