You can query SQL Server system tables to retrieve the list of all the stored procedure that are available for the end user and applications. The following routine extract their
A procedure is said to contain aliased values if it can refer to the same memory addresses in two or more distinct ways. A typical example is the following procedure:
When you write lengthy procedures, it is a good habit to change the mouse cursor to an hourglass, and restore it to the original shape when the procedure exits. However,
You probably already know that if you select multiple controls on a form you can use the Property Window to change one of their common property in one single operation.
When you have a long HTML file to edit, scrolling up and down to your working areas can be a real pain. Fortunately, you can apply bookmarks to points in
Components that are implemented as executable files (EXE files) cannot execute in the Microsoft Transaction Server (MTS) runtime environment. The components need to be DLLs that are registered in MTS.
A typical operation in DHTML is to iterate through a collection of objects. Let’s say you’re writing an HTML application that indexes content. Your task is to collect all the
SQL Server 6.5 has an APP_NAME() function which returns the program name for the current session. This function is useful for tracking which client applications are running processes in SQL
It’s often pointed out that the Vector class is expensive to use because all of the methods are synchronized. Java 2 has the LinkedList class, which can serve the same