Icon of program: Foam

Foam for Windows

Download now

Used Foam for Windows?

Editors’ Review

Download.com staff
Foam is a free .NET Windows application designed to simplify the creation of FOR XML EXPLICIT queries for MS SQL Server 2000. It converts structured XML into stored procedures, reducing manual effort and potential errors.

Top Recommended Alternative

  • Pros

    • Free .NET Windows application.
    • Eases creation of FOR XML EXPLICIT queries.
    • Parses structured XML to generate procedure.
    • Supports parameters, constraints, and ORDER BY criteria.
    • Built-in rules minimize errors in procedure structure.

  • Cons

    • Does not cover all complexities of FOR XML EXPLICIT.
Icon of program: Foam

Foam for Windows

Download now

Used Foam for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1.1
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows ME
  • Windows 98
  • Windows XP
  • Windows 10
  • Windows 2000
  • Windows NT
Additional Requirements
Windows 98/Me/NT/2000/XP, Microsoft .Net Framework
POPULARITY
Total Downloads
2,821
Downloads Last Week
0
Report Software

Program available in other languages

Last Updated

User Reviews

5/5

2 User Votes

Developer’s Description

By digital nothing design
Convert an XML document into a MS SQL Server 2000 stored procedure as FOR XML EXPLICT.
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.
Download.com
Your review for Foam