Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Foam - FOR XML EXPLICIT Tool
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 08/09/2002 :  08:36:35  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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."

Article Link.

Flowing Fount of Yak Knowledge

2878 Posts

Posted - 08/09/2002 :  11:42:24  Show Profile  Reply with Quote
Is there an article here or is this just (free) avertising?

Jay White
Go to Top of Page

Chief SQLTeam Crack Dealer

4149 Posts

Posted - 08/09/2002 :  12:27:21  Show Profile  Visit graz's Homepage  Reply with Quote
Well, with a little cleanup it's a link to a free tool.

Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Posting Yak Master

208 Posts

Posted - 08/13/2002 :  16:56:36  Show Profile  Reply with Quote
As Graz states, it is a tool for SQL Server developers. In my original forum post I had a little disclaimer about how I hoped this didn't come across as a cheesy sales pitch.

No there's no article, this was the place recommended by Graz for me to submit the link. So to answer your this advertising? Yes. But it's certainly not for something that will be making me money, just trying to help other developers.


Go to Top of Page

Starting Member

1 Posts

Posted - 10/04/2002 :  14:22:59  Show Profile  Visit kenlefeb's Homepage  Send kenlefeb a Yahoo! Message  Reply with Quote

...Foam does this by taking an XML document that you have formatted according to the incredibly simple structure specified below,...

Article Link.

Where is the "simple structure specified below"? I can't find it on the website at the end of this link.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000