Tip Bank

Using the Send method of the Ping class (in System.Net.NetworkInformation namespace) takes the hostname as a parameter. This captures the reply in the PingReply object, as shown below: //CodePing ping

This tip shows how to get the keys generated for the rows added by an INSERT statement. Statement st=null;PreparedStatement pst=null;Connection conn=null;ResultSet rs=null;ResultSetMetaData rsmd=null;…try { st= conn.createStatement(); }catch (SQLException e) {System.out.println(e.getMessage());}try

Microsoft Word has a function that lets you convert text into a table very quickly. Suppose you have a word list that you think would be better displayed in a

ActiveX Data Objects (ADO) is a proven technology to access various data sources on computers that run Microsoft Windows. It provides an abstract interface to data stored in a wide

The SQL DISTINCT clause isn’t case sensitive, which means that your query might end up pulling records with different cases. A simple fix for this is to use the COLLATE

This tip outlines two simple methods that help you to convert a number from the “little-endian” format to the “big-endian” format. // 2-byte numberint SHORT_little_endian_TO_big_endian(int i){ return ((i>>8)&0xff)+((i

The NEWID() function returns a uniqueidentifier for each row of data that is returned. Execute the following query in the AdventureWorks database: select top 5 productid, name from production.productorder by

Here’s how to declare some important variables in XQuery: declare variable $v as document-node(element(*,xdt:untyped)) external;: Use this variable to pass an XML tree to a XQuery query. declare namespace nameSpace=”http://nameSpace.org”;

The following four steps outline a shortcut to finding the namespace for a .NET class. Type the name of the class in the CodeWindow. Place the cursor in this name.