Foam - FOR XML EXPLICIT Tool

By Bill Graziano on 9 August 2002 | Tags: Tools


Steve submitted "Foam is a free .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."

Link: Foam - FOR XML EXPLICIT Tool


Related Articles

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Free online SQL Formatter (5 April 2006)

Free tools for SQL Server (2 March 2006)

Software Review: SQLCompare (27 April 2004)

Compare SQL Server databases (2 May 2003)

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III (7 August 2002)

How to troubleshoot orphan users in SQL Server databases? (6 August 2002)

Working with email addresses in SQL Server! (21 July 2002)

Other Recent Forum Posts

Install visual studio and MS SQL server (77m)

Find data source of created SSRS report (19h)

MySQL Union of multiple tables with different number of columns, ordered by another table to get the changed columns name (1d)

How do I group individual events by year? (2d)

Why Am I unable to request Forgotten Password? (2d)

FileTables or Remote BLOB Store SQL Server 2017 (2d)

SQL JSON_Query is not working as expected when using case with For Json Auto or For Json Path (2d)

Patients_summative (2d)

- Advertisement -