Foam is a .Net Windows application that is used to ease the creation of FOR
XML EXPLICIT queries for use with MS SQL Server 2000. Foam does this by taking
an XML document that you have formatted according to the incredibly simple
structure specified below, and then parsing through the document to create the
appropriate FOR XML EXPLICIT structure. This is the absolute base functionality
of Foam.
With Foam, you can further specify parameters,
constraints(FROM/WHERE clauses), and ORDER BY criteria. Foam will take the
information that it has been given, and format it, and place it in the
appropriate location for the stored procedure.
While Foam cannot hope to
cover all the snags of working with FOR XML EXPLICIT, it does have some rules
built in to create the procedure structure as accurately as possible to minimize
errors. The more information you provide Foam with, the less chance of errors
and need for debugging there will be at the end.
If you have questions about Foam, please email
foam@digitalnothing.com.
Download Foam - v1.1.2
Download .Net Framework
|