Foam - FOR XML EXPLICIT Tool

By Bill Graziano on 9 August 2002 | 4 Comments | 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." Follow the link to Foam - FOR XML EXPLICIT Tool...

Discuss this article: 4 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

SQL server features (6 Replies)

DBCC CHECKDB RUNNING TWICE! (1 Reply)

DBCC CHECKDB RUNNING TWICE! (1 Reply)

LOGIN PROBLEMS (1 Reply)

select with max and min dates (1 Reply)

Converting English Language to Sql queries(HELP!!) (5 Replies)

3 questions regarding Logfiles and Tail Log (4 Replies)

Update table with duplicate records (4 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -