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.
There are three ways to emit a beep in Java: Use an AU audio file: In Java, AU files need to be created at a sample rate of 8000. Higher