Question: Is there a script that can gauge site visitors’ net connection speed and route them to the proper link? In particular, I’d like to “auto link” my real video

In SQL Server 7.0, dynamic resource allocation lets disk and memory usage scale to meet changing database demands. This flexibility lets SQL Server provide better performance and simplifies managing the

Internet Explorer 5.0 makes printing pages from within your code simple. The print() method is now exposed off the window object in IE5. It presents the print dialog for the

Java uses a big endian data structure, but Intel-based computers and some others use a little endian format. You may run into problems reading binary data saved in little endian

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: 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: 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: 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: 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: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

Question: What is the data type for time? Example: 8:45 am Answer: What you really have is the tail end of a datetime data type. You can get it back

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

Question: When I run SQLMaint to update statistics on one of our SQL 6.5 servers, the table statistics get updated but it returns an error message: [4] Update Statistics…[Microsoft SQL-DMO]

Question: What situation produces incorrect results in an uncontrolled shared update? Answer: I’m not certain what you mean; however, reading uncommitted (i.e., dirty) data springs to mind. Are you trying

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

Question: I want to know where Visual Foxpro came from. Can you give me a history of this language? Answer: Visual Foxpro evolved from a product called Foxpro. Foxpro started

Question: Is there a way, using Visual FoxPro, to determine the maximum number of characters (not spaces) in a field? I am working with a table that has over 3

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: 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: What are the minimum required run-time files for a Visual FoxPro 5 application setup? Answer: The easiest way to find the minimum required run-time files is to do this:

Question: I’m equally comfortable using both VB and FoxPro. Each product has its pros and cons. I think VB has a better developed IDE and debugging facilities. FoxPro, on the

Question: Is GoTo a valid Statement in ASP? I need to do something like this: If x=y then Goto THEREend ifTHERE: bla bla bla Answer: There is no GoTo statement

Question: My company has been using R:BASE in the past and we recently upgraded our network and installed SQL. How can I migrate my old R:BASE data into SQL? I

Question: I need to pass large fields of text. Problem is, some of the text has single quotes in it ( ‘ ). How do I pass these text fields

Question: What is the difference between static and dynamic SQL? For that matter, what are they? Answer: Static SQL statements are embedded in the source code of a program. They

Question: I have a client that has a massively disorganized set of linked databases in Elustra on a UNIX server. They want to take everything, convert it to SQL, and

Question: I am using VFP 5.0. When I create an EXE file, how can I get my own icon associated with it? (instead of a Fox head) Answer: First, when

Question: Is there any way to change the ownership of files and directories with scripts or programs? Answer: You can use the SubInAcl.exe file (included in the NT 4.0 Resource

Question: I have been asked to develop a database of imagery from a company’s slide collection that needs to be incorporated into a Web site. Does SQL support binary files?

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