(Tony Patton) As .NET developers, we often find ourselves waist deep in SQL Server queries and stored procedures. A good example is an ASP.NET application I recently developed and delivered to the client for testing. The application utilized an existing SQL Server database with most of the T-SQL con
Author: SSWUG Research
Deploy Java UDRs through Web services on Informix using Rational Application Developer
(Soumita Ghosh, Sobha Rani Cheruku and Akhilesh Kumar Tiwary) A common requirement these days for database application developers is to be able to expose functions that access data on the Web. In this article, we show you how to expose an Informix user-defined routine (UDR) or user-defined datatype
Developing T-SQL Stored Procedures to Deal with Lookup Tables
(Jagadish Chaterjee) In this article, I shall go through a set of Transact-SQL stored procedures which are very frequently used for CRUD operations on lookup tables. My upcoming articles will deal with DAL (Data Access Layers) in .NET based on these stored procedures.
What’s in a name – The saga continues…
(Willie Favero) Now that DB2 9 has been around for a while on the distributed platform and is well into its beta on the mainframe, I wanted to write an addendum to my May 5 post, “What’s in a name?” and talk a little more about the name of our newest DB2.
Building a TreeView ResultSet with SQL Server 2005
(Ameet Phadnis) In a corporate environment we usually face coding tasks to display results in Treeview. The tasks may include displaying corporate structure or in programs displaying the menu structure. Around 5 to 6 years ago when I was tasked with a similar kind of assignment, my manager wanted
MDX Operators: The IsLeaf() Operator: Conditional Logic within Calculations
(William Pearson) We have noted in several articles that, while MDX functions comprise the lion’s share of the MDX Essential series, numerous operators are provided within the language. Of the logical, comparison, set, string, and unary operators provided by MDX, we will examine another logical oper
On the Use of XML Schema for Normative Contributions to W3C Recommendations
(John Boyer) The XML Schema language is a good language for capturing the syntactic constraints of an XML vocabulary. But let’s face it, it is really designed more for describing data. It’s just not powerful enough to be used for making normative contributions to W3C Recommendations like, say, XForm
Creating a Login Script for a PHP/MySQL Blogging System
In this three-part tutorial we are going to be creating an open blogging system. We are also going to provide scripts that will make it possible to switch to a closed blogging system. This article, which is the first part, will cover the creation of the login scripts for a closed system.
Compatible Stylesheets with xsl:fallback
(Anghel Leonard) The following code is an example of how to use the xsl:fallback element to achieve full compatibility between XSLT different versions.
Generate external table definitions from SQL*Loader
(Bob Watkins) External tables, introduced in Oracle 9i, enable you to map a sequential text file to an Oracle table definition. Once the external table is defined, you can use the full power of the SQL SELECT statement—including parallel querying—to process it.