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