In SQL Server 7.0, you should set the original size of the transaction log file to a reasonable size to prevent the file from expanding automatically as more transaction log
User Connections parameter is used to set the maximum number of simultaneous connections to SQL Server. However, the actual number of connections may be less, depending on database environment. The
When you overload the subscript operator, remember that the non-const version of the overloaded operator should return an object by reference, not by value. Otherwise, you won’t be able to
Question: I have a table with five columns. They are “No. of People,” “Tour1,” Tour2,” “Tour3,” and “Tour4.” I want to set up a query that shows me how many
Question: I have tried the following code: SELECT distinct title, id from table where …..order by title and it returns: A 001A 002B 003 The result I want is: A
Question: I have a table like this one: Day_Period_Money (daydate date, period number, amount number); Here is an example of some data: daydate period amount01/01/99 1 1001/01/99 2 2001/01/99 3
Question: I have a table that contains numbers defined as varchar. How do I convert from varchar to number? Answer: Try using the CONVERT function. If that is not an
Question: I have this real cool function to determine if a Form is Open which works fine in Access 97, but not in VB 6.0 because it does not support
Question: I am creating a data warehouse and need to SELECT and INSERT data across servers using SQL Server 6.5. Is there any way I can code this in my