This is a very simple but time-saving and powerful tip to build a dynamicSQL query (in SQL Server 7.0) that updates a particular column value present in all tables. And
Question: I tried a DTS export of a table to an Excel file. The data types of all the columns in the table are varchar. When it exports to the
Question: I have a table that stores test answers. It looks something like this: Student Date_taken Q1 Q2 Q3 … Q78 If each question (Q%) is true/false (ENUM(”,’T’,’F’)), how do
Question: I have some complex engine control software that has to run under MS-DOS 6.2, but it needs to transfer data to SQL Server 7. What’s the best way to
If you have a recordset already created and want to filter it by some criteria, you can use the Filter property of the recordset to do it. Just change the
You can use the dot operator (.) in XSL transformation stylesheets to refer to, effectively, “whatever element was just identified.” Let’s say you had this template in a stylesheet: Say
If you’re getting a bunch of data for an ASP page, you can retrieve all the data through a single stored procedure and through a single call. Here’s what your
Moving your ASP code to compiled components is always a good idea. Compiled components enable fast execution, along with easy development, debugging, and testing. For example, creating a record set
Question: I have tried to reorganize Informix chunks on my disks. So I stopped the Informix and started to copy chunks to a new location with a cplv command (AIX).