(Keyvan Nayyeri) In previous versions of T-SQL you had to use a trigger to retrieve data from inserted, updated or deleted rows in tables which wasn’t very straightforward. SQL Server 2005 adds a new clause to T-SQL to simplify this task. OUTPUT is this clause.
Other News
Logical Functions: IsAncestor(): Conditional Logic within Filter Expressions
(William Pearson) In this article, we will examine IsAncestor(), once again as a conditional logic modifier, but within the context of a filter. Combining IsAncestor() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the prac
Generate an XML Document from an Object Model with JAXB 2
(Antonio Goncalves) Java offers various ways to manipulate XML, including the following: –Use simple file I/O or javax.xml.stream.XmlStreamWriter. –Use XML serialization with java.beans.XMLEncoder, which generates an XML representation of a Java Bean in the same way ObjectOutputStream can be
SQL Server XML Cribsheet
(Robyn Page) This is written with the modest ambition of providing a brief overview of XML as it now exists in SQL Server, and the reasons for its presence. It is designed to supplement articles such as Beginning SQL Server 2005 XML Programming.
Transform and integrate data using WebSphere DataStage XML and Web services packs
(Li Chen, Xiong Xiong and DaWei Zhang) IBM WebSphere DataStage XML and Web services packs are components of DataStage that help to deliver fast data integration solutions when XML and Web services are involved. Explore the main functions and operations of the DataStage Web Services and XML packs. Le
So, when did that row last get changed?
(Willie Favero) Do you have a need to know when a row was last changed or inserted? Would you like to find out using a feature of SQL and have everything to track a last changed just happen automatically. If you do, then does DB2 9 for z/OS have another cool little feature for you. Here are a couple
Introducing MySQL Table Maintainer
(Xaprb) MySQL Table Maintainer is a new utility to help you run table maintenance commands (ANALYZE, CHECK, OPTIMIZE, REPAIR) on your MySQL tables. It’s part of the MySQL toolkit.
SelectViews: Kimberly Tripp, Paul Randal join us for a wide-ranging interview.
Video Programming for IT Professionals
Oracle E-Business Suite 12 gets new manufacturing applications
(Mark Brunelli) Oracle E-Business Suite 12 is offering new capabilities for companies in the discrete and process manufacturing industries. (R)
To Trust, or Not to Trust?
(Priya Lakshminarayanan) Validation of an XML document against an Xml Schema guarantees that the structure and content of the xml conforms to the types defined in the schema. Does this mean that we automatically elevate the trust level of a document that has passed schema validation? Can we use sche