The FOR XML clause is valid only in the SELECT statement and is subject to these limitations: FOR XML is not valid in subselections, whether it is in UPDATE, INSERT, or DELETE statements, a nested SELECT statement, or other statements (SELECT INTO, assignment).
Other News
Creating Tables (How-to)
Read more on how to create tables with SQL, the different options available and more. You’ll even have a chance to try your statements right on the site.
Specify Constraints in the Oracle XML DB
Oracle XML DB is a set of built-in high-performance storage and retrieval technologies developed especially for XML. It enables you to constrain XML data according to XML schema definitions and hence achieve control over relationships that structured data has always enjoyed. Alongside its other feat
Table Check Constraints
A check constraint is a rule enforced by DB2 that specifies the values allowed in one or more columns of every row of a table. Prior to DB2 V4.1, check constraints could be specified on views, but their usefulness was quite limited. Find out more about constraints, how to create them and more wi
WS-I, Exposing Stored Procedures as Web Services, and More
(Aaron Skonnard) WS-I stands for the Web Services Interoperability Organization, a new industry consortium whose goal is to promote interoperability across Web Services implementations. The WS-I was announced in February of this year. Founding members include Microsoft®, IBM, Intel, Oracle, SAP, HP,
Migrating Constraints from Oracle to SQL Server
Regardless of the database management system (DBMS) you are using, it is recommended that you always name your constraints. If you do not name your constraints, both Oracle and Microsoft® SQL Server™ name them for you. Because Oracle and SQL Server use different default naming conventions, the d
FDIC Looks to Curb Errors With XML Variant
(Renee Boucher Ferguson) About half of the 8.500 banks that report quarterly earnings to the Federal Deposit Insurance Corp. do so with mistakes intact. The Washington-based FDIC, along with the Federal Reserve Board and the Office of the Comptroller of the Currency, are trying to correct that p
Windows Update 5 Prepped for XP SP2, New IE
(David Worthington and Nate Mook) Microsoft has put pen to paper in outlining its vision for Windows Update. Even though version 4 is still in use by beta testers, Microsoft has drawn up its roadmap for the service’s next generation, which includes SP2 for Windows XP and an updated release of Intern
PeopleSoft sued over rebate program
(Ellen Lee) PeopleSoft Inc.’s “customer assurance program,” which allows customers to get up to five times their money back if Oracle Corp. succeeds in its $7.3 billion hostile takeover bid and dismantles PeopleSoft’s software, has come under the microscope after a group of shareholders asked a judg
IBM Takes the Veil Off Project ‘Vela’
(Darryl K. Taft) IBM Corp. has put a name on its strategy to componentize its middleware on the way to delivering service-oriented architectures (SOAs), primarily through componentizing its WebSphere application server in a project known as “Vela,” company officials said.