SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

USA
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.

Page47
Flowing Fount of Yak Knowledge

USA
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
{0}
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 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

Blastrix
Posting Yak Master

208 Posts

Posted - 08/13/2002 :  16:56:36  Show Profile  Reply with Quote
Page47,
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 question...is this advertising? Yes. But it's certainly not for something that will be making me money, just trying to help other developers.

Steve

Go to Top of Page

kenlefeb
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
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  
 New 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.08 seconds. Powered By: Snitz Forums 2000