The proliferation of handheld devices and embedded systems revives old programming and design considerations that existed in the olden days, when every byte of memory and every CPU cycle counted.

Most applications contain a loop that contains a parameterized query, which is executed many times depending on some logic. This requires a network round trip between the computer running the

When SQL Server completes the execution of a T-SQL statement, @@ERROR is set to the value 0 if the statement is executed successfully. Otherwise SQL Server returns an error number.

If you already know that the execution of your SQL statement will return a single row of data, then you should always prefer stored procedures with output parameters in place

When displaying the contents of a database memo field in a Web page, you may find that you are losing the formatting of the original text. That’s because HTML is

Java makes working with threads relatively straight forward. However, there are situations, or anomalies that can arise due to improper design of a thread-based code. The following provides you with

SQL Server 7.0 uses deferred name resolution in stored procedures, triggers, and statement batches. It allows the creation of stored procedures that reference objects that do not yet exist. During

Java Archive (JAR) files are compressed files into which you can store many files. If you place the many classes that your application, or applet needin a JAR file, you

The Active Server Pages HTMLEncode function is great for handling strings that come from a database, especially if the string includes foreign characters. However, you can get into trouble if

If you are trying to count the number of records within a recordset but you’re getting back the value -1, then chances are you’re using the wrong cursor type. In

Question: If three records have been written to a text file(each record having 3 int fields) and each integer field is seperated by a comma, how do you retrieve only

Question: Let’s say I have a class foo, with a lot of functions that take no arguments and return SomeType: SomeType foo::bar()SomeType foo::quux()SomeType foo::quuux()SomeType foo::quuuux() Now I have a pointer

Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongPrivate Const TV_FIRST =

Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongPrivate Const TVM_GETNEXTITEM =

Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongPrivate Const TV_FIRST =

Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _ lParam As Any) As LongPrivate Const TV_FIRST =

In plain VB there is no way to determine or change the height of node elements in a TreeView control. All you need to accomplish both tasks, however, is send

Java hashtables are widely used to maintain a mapping relationship between objects. It is easy to store, and retrieve an object from a hashtable using an arbitrary key. Sometimes, it

A reader posted this question on one of the C++ newsgroups. Assuming B is a base class for D, his program looks like this: void g (B* p) ; void

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).