How can I update three columns in table A from three columns in table B in one UPDATE statement? Check out the answer!
Other News
Use SQL Server Triggers to Track Unauthorized Database Changes
What do you do when you’re tasked with determining the source of unauthorized modifications to your database? Use SQL Server triggers and let these useful procedures do the work for you.
Troubleshooting Replication Problems
Alexander Chigrik’s new replication troubleshooting checklist is the first resource you should consult when attempting to diagnose and solve replication-related issues.
Case-insensitive enumerations
IBM’s own XML ace Doug Tidwell offers one curious reader an automated solution for defining a case-insensitive enumeration that’s straightforward, standards-compliant, and requires little work on the developer’s part. Several code samples are included.
Updated release of XVIF
Eric van der Vlist announced version 0.2 of his XML Validation Interoperability Framework (XVIF), “including a partial implementation of Relax NG and a very partial implementation of W3C XML Schema datatypes”.
XML Powers Document Builders
By Peter Coffee – Adobe’s FrameMaker 7.0 and Corel’s Ventura 10 ably handle Web document management tasks but miss some of the basics found in lowly word processors.
Working with a Metaschema
by Will Provost – If in its entire lifespan W3C XML Schema (WXS) were used merely to validate document after earnest little document, it would have proven its worth. Happily, schemas are useful for much more than validation. XML applications can extrapolate all sorts of functionality from an XML voc
How to Install Only the SQL Server Books Online
This article describes how to manually install SQL Server Books Online if they were not installed when the product was originally installed.
How to include Text, nText and Image datatypes in a Union query
As you probably know, in Microsoft database parlance the Text, nText and Image datatypes all hold very large amounts of data. If you’ve ever tried to add these types to a Union query in Visual Basic, the query probably generated errors, claiming that the Text, nText or Image data type can’t be selec
The O’Reilly Factor: Inside Perl for Oracle DBAs
By Vance McCarthy – Perl can be one of the Oracle DBA’s most powerful tools, thanks to its power as a solution for transforming and gluing data together. That’s the premise of O’Reilly’s latest title, “Perl for Oracle DBAs — Making Life Easier for the Oracle Database Administrators”