Other News

Community

Servlets and JSP Step Up

(Budi Kurniawan) The upcoming J2EE 1.4 includes the new Servlet 2.4 and JavaServer Pages (JSP) 2.0 technologies for Web application development in Java. This article offers a look at the new features in both specifications and provides sample code for each feature where appropriate. The article assu

Community

Basic and complex SQL joins made easy

When you perform an INNER JOIN, only rows that match up are returned. Any time a row from either table doesn’t have corresponding values from the other table, it is disregarded. Because stray rows aren’t included, you don’t have any of the “left” and “right” nonsense to deal with and the order in wh

Community

XQuery Language Expressions

(Kurt Cagle) When you combine XML, which is essentially an open data format independent of any specific data-formatting language, with a universal addressing mechanism such as URLs, great things happen. These two factors together make the endpoints of a transaction transparent to the kind of technol

Community

Exploring SQL Server Triggers

(John Papa) Triggers are one of the core tools available in relational databases such as SQL Server™ 2000. As one of the mainstays of SQL Server database programming, triggers also happen to be one of the topics that I get most of the questions about. In this month’s installment of Data Points, I wi