Tip Bank

DevX

SQL Using Like to Search for

Question: I have created a database of journal articles and want to offer users the ability to search the Author field for the surnames of authors. Most of the articles

DevX

Automatically Logging Users Off

Question: I am running SQL Server 7.0 with 20 user licenses. I have about 40 users, of which only 10 are logged on at once. The problem I am running

DevX

Setup of SQL on the Client Side

Question: I own a company and have two database servers. One is MS SQL6.5 and the other is a Sybase server. I want to access both servers on a client

DevX

Function Sequence Error

Question: I have WinNT4.0, Service Pack 5.0 SQL Server7.0, ODBC Driver for SQL 3.70.06.23. I have a servlet program that connects to a JDBC-ODBC bridge and accesses the database. If

DevX

Importing Dates Earlier Than 1752

Question: When I try to import data to SQL, I find a problem in exporting the date values that occur earlier than the year 1752. Since I am working in

DevX

Migration from ACT to MS SQL Server

Question: We currently have two contact databases in ACT. One of them is growing exponentially and at 70,000 records we are already experiencing problems. We are considering switching to MS

DevX

Data Extract and Input Using SQL

Question: We use Dunn & Bradstreet’s Smart Streem System with a subledger that has a high volume of data, and as of this point has to be identified manually and