This article by Garth Wells covers building a dynamic where clause. And the really neat part is that you don't actually need to write dynamic SQL. This is soooo much simpler.
Community
XML Workshop
XML Workshop is the course for developers eager to learn XML and put it to use in their applications. This 3-day, hands-on course takes you through XML technologies theory and practice starting with XML Documents and Infosets all the way to SOAP and Biztalk. Topics covered include XML DOM, SAX, XSLT
XML and Binary Data
Many people wonder how to send images using XML. Darshan demonstrates in his article how to send binary data as part of an XML document, using base64 encoding.
New W3C XML Schema Slanted Toward West
Opinion By Lee Anne Phillips At long last, XML Schema is on its way to becoming reality with the release of the still-flawed-but-far-better-than-what-we-have-now, three-part specification to Candidate status at W3C. Although several issues remain controversial—notably the utter failure of the S
Book Review: Professional SQL Server 7 Programming
From SQLTeam.com Wrox is one of the better technical publishing companies out there. They consistently produce great books on a variety of topics. You can always find their books by looking for the bright red spine. I have four of their books now. Two I use regularly myself (HTML and ASP Databa
Embarcadero DBArtisan Brings Graphical Database Administration to IBM DB2 for OS/390
Embarcadero Technologies, Inc., (Nasdaq: EMBT) provider of database lifecycle management solutions, announced DBArtisan, its award-winning database administration tool is available for IBM DB2 for OS/390. Database administrators (DBA’s) managing DB2 on OS/390 can take advantage of DBArtisan’s Window
How to Find the Best XML Server for You
No one XML server fits all needs. Your choice depends on factors such as size and linearity of data.
Introduction to BXXP
BXXP is a generic application protocol framework for connection-oriented, asynchronous request/response interactions based Internet applications. In other words, BXXP is a general purpose framework for creating Internet application protocols that serve as an alternative to aging HTTP used for Web br
StarOffice XML project continues progress on XML file format
This article by Michael Smith tells us…The OpenOffice/StarOffice XML Project team is continuing to make progress on their goals of developing and refining "an open and ubiquitous XML-based file format for office documents" and of providing an open reference implementation of the format to
Horizontal partitioning in SQL7
Horizontal partitioning is a way of splitting a table (or a set of tables) into smaller pieces. This is usually accomplished by splitting the table by key values, and it is usually done to make merge replication feasible.