Tip Bank

Question: I have the following dump for MySQL and am having a problem getting it corrected for MS SQL. Can you help? Here is the dump file: # MySQL dump

Question: I have the following: sql=”select * from products” How do I sort or order by two columns retrieved in the “*”? Answer: You need to specify them directly in

Question: I have a form with a rather large text area inputting over 4000 characters of data into an Access database. I tried to upload it all at once, and

If you are developing COM components which run under MTS (Microsoft Transaction Server) then you may want to replicate one machine’s catalog to another machine. Here is a command line

If you want to improve performance of your application then you should always try to use strict type variables. You can use strict type (or strongly typed) variables by referencing

SQL Server 7.0 allows the tempdb system database to expand automatically as needed, rather than failing with an out-of-space error. If a reporting application needs a lot of space in

In order to run this tech tip you need following things:(a) VB5 or VB6(b) Reference to Type Lib information object component (TLIBINF32.dll). This function takes in the name of the

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in SQL Server is to roll back only the statement that generated the

Even if we’re living in a 32-bit world, and closer and closer to the 64-bit day, 16-bit programs are still running out there. Knowing whether a given EXE is 32-bit