Tip Bank

Question: I plan to create a SQL Server 7 database containing about 40 – 70GB of data. The data will be generated by queries. How should I spend my money

Question: I know that you can execute a program from a known drive using the system command, but what if you don’t know the drive letter? I am trying to

Question: I am trying to list out the contents of a field, and there are so many, that I need to send the output to a file. Can you tell

Question: I have a database that I would like to navigate on the primary key in alphabetical order using SQL statements. I would like to find out if there is

Question: Could you please explain, along with examples, how to use the commands GetFileTime and CompareFileTime? I read the help topics but find it hard to digest what they say.

Question: Our maximum int value is 32,768, but our minimum int value is -32,767. Why aren’t they the same? Answer: Because a short integer (2 bytes or 16 bits) can

Question: When should I make member variables protected and when should I make them private? Is it a good practice to ignore protected variables? It seems to me that most

Question: When inserting data into a table that has an identity column that is also the key, the following error occurs: Non-Blob column in table is required to perform operation.

Question: How can I do a C++ program that converts simple C programs to assembly programs? Answer: This is a very complicated task. The first step would be a parser