Tip Bank

Question: I have a small SQL Server 6.5 database running on NT Workstation. From my workstation I can ping that machine and I can map a drive to that machine.

Question: Please describe the basic components of a table in the relational model. Answer: A table has an intension and an extension. You can think of the intension of a

Question: I have a simple query using an SQL statement for returning matching records from an IIS Web server using ASP. I need a new query which returns a match

Question: I want to use Union to union two different tables, but they are in different databases. An error message told me that I can’t use Union in this way.

Question: I’m trying to get the Identity of records as I insert them into my database. I have tried: OrderID = DataConn.Execute(“SELECT @@IDENTITY FROM Orders”). But this returns a syntax

Question: I am having trouble figuring out how to make a report dealing with duplicates. I need to selcet from a table only instances where the first 10 characters of

If you are developing COM components that run under MTS (Microsoft Transaction Server), you will notice that many times your transaction automatically gets aborted. You can easily avoid this situation

The Visual InterDev Scripting Object Model (SOM) offers many time saving techniques for coding Web pages and remote scripting. However, you can lose a lot of time when the finicky

The import directive in Java can sometimes be confusing. For example, if you put this line at the top of your source file: import java.util.*; Do all the classes in