By Itzik Ben-Gan – Auxiliary tables are extra, “helper” tables you create in your database specifically to help you provide T-SQL solutions. With auxiliary tables, you can write shorter, simpler, and more elegant code. I can best explain the concept of using auxiliary tables through an example. In t
Other News
Undocumented SQL Server 7.0 System Tables
by Alexander Chigrik – In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database).
Keyword search using a tally or sequence table
From SQLTeam – Ryan writes “I am looking for a way of creating a stored procedure that will carry out a keyword search without building up the SQL dynamically in the stored procedure. What I’m after is a method of doing this that doesn’t require me to build up a huge string.”
Intuit Enables Application Integration with QuickBooks Extensible Markup Language (qbXML)
Two preliminary XML DTDs have been published through the Intuit Developer Network as part of Intuit's effort to open up its APIs to third-party developers. Intuit's QuickBooks Extensible Markup Language (qbXML) is a language at the core of a new framework that allows electronic exchange, cre
Using JDBC to extract data into XML
By Nicholas Chase – This tutorial is designed to assist Java developers who need to extract information from a database and place it into an XML document. The tutorial assumes that you are already familiar with Java and XML in general, and the Document Object Model (DOM) in particular. You sh
Modeling XML Vocabularies with UML: Part III
by Dave Carlson – This article is the third installment in a series on using UML to model XML vocabularies. The examples are based on a simple purchase order schema included in the W3C XML Schema Primer, and we've followed an incremental development approach to define and refine this vocabulary
OLAP Survey Respondents Give Analysis Services High Marks
By Kathy Blomstrom – SQL Server 2000’s integrated Analysis Services functionality came out on top in several categories in the recent 2001 OLAP Survey, conducted by Survey.com and published by The OLAP Report. The survey asked more than 644 OLAP users from 46 countries to rate 11 vendors on implemen
AGS SQL Scribe
SQL Scribe is a documentation tool created with the developer in mind. SQL Scribe will interrogate a SQL 7.0 or 2000 database and extract the database schema. This schema information is stored in an MS Access 2000 database. Using any readily available browser the developers can navigate though the
Advanced SQL Techniques – Part 1: Analyzing Duplicate Records
By David Penton – The following is an analysis of records in a table, some of which may be duplicated. Many different things can be accomplished with this method, including looking for duplicates, looking for records that are duplicated n times, deleting duplicates, etc.
Consortium Creates UML/XML-Based 'ArapXML' to Support General Ledger Integration on the Internet
Several accounting firms are collaborating on the design of UML models and XML notation for ArapXML, formulated in response to an OMG RFP 'Account Receivable – Account Payable AR/AP Facility. Request For Proposal'. The Project includes research, discussion, documenting use cases and requirem