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
There are certain scenarios where you need to display the create date or the last modified date of your document. There is a “LastModified” method in the “document” object which
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