by Justin Gunther As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM cla
Author: SSWUG Research
SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability
(Carl Nolan) SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in fu
Entities and XSLT
by Bob DuCharme In XML, entities are named units of storage. Their names are assigned and associated with storage units in a DTD's entity declarations. These units may be internal entities, whose contents are specified as a string in the entity declaration itself, or they may be external en
XHTML Tags Reference
XHTML is a reformulation of HTML 4 as an XML 1.0 application. The stricter nature of XML requires you to follow more rules than before when creating documents:
Saving HTML Form Data to XML
By Michael QuallsUsually form submissions in ASP are written to some sort of database management system. However, if you need your form submission data to be more portable, it can be written to an XML file. This is especially useful when the data you are gathering on your Web site will be sent t
Attunity Introduces Industry’s First JCA-Based Framework for Application Integration
Attunity Ltd. (NASDAQ:ATTU – news), a leader in eBusiness and B2B integration solutions, today announced more powerful application and data integration capabilities for Attunity Connect(TM), a solution widely used by companies around the globe to seamlessly unite web, mainframe, and legacy applicati
Dynamic Cross-Tabs/Pivot Tables
IMHO, the best feature of MS Access is the TRANSFORM statement, used to create cross-tabs/pivot tables. It does all of the work of dynamically generating the cross-tabulation and the summary calculations. T-SQL unfortunately doesn't have this statement, so you're stuck using complicated SQL
Querying Data with ADO.Net
By Sean Vaccariello With ADO.Net it has never been easier to parameterize data from a SQL database. This article focuses on retrieving selective data from a SQL database using ADO.Net. There's not much more to say, so let's get started.
Perl bindings for GNOME XSLT processor
By Edd Dumbill Matt Sergeant has released Perl bindings for the XSLT processor in Daniel Veillard's GNOME libxml, reporting significant performance advantage over Sablotron.
Extensions to XSLT
by Leigh Dodds 2001 is certainly turning into an eventful year for the XML community. The new year began with the community-led development of RDDL (see Old Ghosts: XML Namespaces), and the past month has seen a lot of heated debate over the future directions of many core W3C specifications, in