This query returns a list of all the user-defined functions in a SQL Server database. In a T-SQL Window, write this query, substituting the appropriate database name for the db_name

The String.Split method has few limitations. For example, it does not support splits on duplicate delimiters such as double pipe (||) characters, double tildes (~~), or double colons (::). The

You can select which column to sort a SELECT statement by at runtime, using just one parameter. To do this, declare one parameter and use it with a CASE command.

Type conversions are more error-prone than most code, so it’s useful to have ways to convert types in ways you know will work. The CanConvert method in this tip checks

First, launch Eclipse with increased memory options, which you can do as follows (increase these values as needed, but don’t exceed your available memory): eclipse.exe -vmargs -Xmx512M -XX:MaxPermSize=256M Sometimes, the

You can find out which session is causing blocking problems using this SQL command: SELECT blocking_session, sid, serial#, wait_class, seconds_in_wait FROM v$session WHERE blocking_session IS NOT NULLORDER BY blocking_session;

Using the following code snippet you can run any application (such as Word, Excel, etc.) or open any file whose extension is associated with an application, such as .doc, .txt,

The simple way to convert Hashtable keys or values into an ArrayList is to use a constructor that takes a list of values. The Hashtable.Keys and Hashtable.Values properties both return

It can be annoying to open the IDE every time you need to build a .NET solution or project. Fortunately, .NET ships with a command-line utility called devenv.exe that you

Follow these steps: Open the Registry editor. Find the key HKEY_CLASSES_ROOTAllFilesystemObjectsshellexContextMenuHandlers. Right-click on that item and select New ? Key from the context menu to create a new key. Name

Here’s how to find out which session is waiting for a shared resource to be released: Column host format a6;Column username format a10;Column os_user format a8;Column program format a30;Column tsname

Unlike C/C++ compilers that produce binary executables, Java produces bytecode. Running bytecode can be difficult for regular users, particularly when the application requires external libraries. There are several solutions to

The code sample below shows how to use the .NET SOAPClient to consume a web service developed in .NET.

An easy way to create and send email in VB (or any other language) is to use the “mailto:” protocol that already works on client computers. The technique makes a

A quick way to view detailed information about a just-thrown exception is to open the Watch window, and type $exception in the watch window.

You can use the code in this tip to make web requests to a remote HTTP server and read the response: try{ // The URL http://www.microsoft.com/en/us/default.aspx // is used here