(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
Author: SSWUG Research
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
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
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
Leverage your Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8
(Raul F. Chong) In the world of information technology today, we are constantly bombarded with new information — new software products, new versions, new features. Leveraging your current knowledge is one way to keep up with this constant change. This article shows you how you can use your cur
Use date functions in the XSLT Standard Library
(Brian Schaffner) The XSLT-SL project provides a rich set of functions that you can use within your XSL stylesheets. These functions include string manipulation, node processing, URI processing, and date functions. This article looks at some of the date functions and how you can use them in your sty
DB2 stored procedures and dynamic cursors
(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
Installing Oracle, PHP, and Apache on Linux
(Robert Clevenger) Are you ready to start using PHP to talk to an Oracle Database? Let’s walk through the steps required to install the Oracle Database, Apache HTTPD Server, and PHP as an Apache module on Linux. Check out the OTN Linux Center to see what versions of Linux are certified for use with
DOM Vs SAX What is best?
(Ravikiran Muvva) In today’s world XML is the popular medium for exchanging data. To make use of that XML Data, it is very important for the sender and receiver to understand and manipulate data. Currently the most popular APIs available for manipulating the XML Documents are DOM and SAX. In this ar
Quick and Dirty RDBMS Tuning
(Steven Hauser) Oracle tuning. Informix tuning. DB2 tuning. PostgreSQL tuning. It doesn’t matter which database you use — RDBMS tuning is all pretty much the same, because database software is all pretty much the same these days. All major relational database systems have an engine, an optimize