Network administrators make use of proxy servers to enhance the security oftheir networks. A proxy server can be seen as a service that managesconnections between the internet and an internal

There is a simple way to resize your javax.swing.JLabels to the text theydisplay.For an instance of javax.swing.JLabel called jLabel1, if there is not LayoutManager installed : jLabel1.setText (“A somewaht long

C and C++ define a special type for pointer arithmetic, namely ptrdiff_t, which is a typedef of a platform-specific signed integral type. You can use a variable of type ptrdiff_t

You cannot initialize an array member in a member-initialization list of a class. For this reason, the following code will not compile: class A { private: char buff[100]; public: A::A()

Normally when a user calls a stored procedure, SQL Server does not create a new data access plan to retrieve the information from the database. The queries used by stored

You can improve performance of your MDAC application by using native OLEDB providers instead of OLEDB provider for ODBC. MDAC 2.0 contains the native OLEDB providers for three SQL data

Question: How do I use SQL Server Query Analyzer to export a query to a text file? I need it pipe-delimited. I think if you can show me how to

System memory is divided into units that are called “pages”. A page consists of 4,096 bytes (4K) on Intel architectures, and on Alpha systems it consists of 8,192 bytes (8K).

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 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 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: How do I get a query to return only a certain number of rows? For instance, a search criterion might return 100 rows, but I only want to see

Question: Since there are no pointers in Java why is there aNullPointerException? Answer: It is a bit misleading to say that Java does not have pointers.Reference variables are very similar

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 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’d like incorporate an inactivity timeout for an application.When there is no mouse or keyboard activity in the application fora certain period of time, I want to close all

Question: I’ve got an Excel workbook composed by a series of pages (worksheets). One of them is called ‘Wholesales’. I’ve tried to retrieve values even with basic syntax: select *

Question: I am in the process of creating an n-tier database application and am stuck at storing images to the SQL Server database. Any help would be appreciated. Obviously, I

Question: What is the SQL standard for concatenation? Answer: In SQL Server, you can do something like SELECT “Me” + “You” gets you MeYou In Oracle, I believe the symbol

Question: How do I perform a word search in SQL? I want to find all rows containing the word “time” by itself and not any rows containing “time” as part

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 written an ActiveX EXE. that handles Batch Reporting requirements on a large amount of data. Even though it is an Out-of-Process “server”, it still seems to execute

Question: I have a class that extends one class and implements an interface.The interface requires a getName() method.At the same time the class I am extending has a getName() functionthat

Question: I am working on a database program that will insert random data into all fields in the database. What the program is supposed to do is look for field

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

Question: How can I move the master and msdb database devices to another disk in SQL Server 6.5? Can I mirror them and then unmirror them, swapping to the mirror

Question: How do I create a toolbar button without also creating a menu item? Answer: Add a menu item as normal and then set the toolbar details for the menu