Tip Bank

Question: We are currently running SQL 6.5 and want to upgrade to SQL 7.0. The machine hosting SQL 6.5 is not robust enough to handle SQL 7.0. We are running

Question: What is the difference between NT servers and NT workstations? Are they different machines or just different operating systems? Answer: NT servers and NT workstations run the same operating

Question: I need to get a handle on my choices for a SQL reporting tool for ad hoc reports. The quick-and-dirty requirements are that it must be able to develop

Question: I am using an array on the client side to create an HTML string that builds a table of data, which the user can then manipulate. Because the array

Question: Are there any special consideration when using an Inner Join and two of the same tables, one used as an alias? What is the ANSI SQL-specific syntax for Inner

Question: I am new to SQL. I need to use Oracle 7, but I need a user name and password. How can I get started? Answer: You need to ask

Question: How can I recover data from my SQL database after a stored procedure replaced a whole table with incorrect values? Answer: Chances are you cannot do so. Well, it

Question: How can I execute an existing DTS package from Visual Basic? Answer: Get an object reference to the package. I do this in Visual FoxPro: loxx=createobject(‘DTS.Package’,’CmdExample’) Then I ask

Question: How do I display a column from a database in a list box? Answer: This presumes you have a view defined somewhere, either remotely or on the server as