Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2002-08-03 : 14:58:26
|
| I hope this doesn't sound too cheesy, like a sales pitch or anything. This application is free.Last night I completed work on an application I call Foam. At the end of this post is some text describing exactly what Foam is and does.With this utility, you pass in an XML document formatted how you want, and it generates the stored procedure code for getting this data using FOR XML EXPLICIT. No more of the exceedingly tedious figuring out which items are at what level, and who's Parent is what Tag, etc...The app is free, so if you are interested in using it, just run off to the link below and download it. The only real criteria is that you be running the MS .Net Framework. If you do not already have it, then you can download it from the link below as well.Foam.zipMS .Net FrameworkIf you have any questions about Foam please contact me here: foam@digitalnothing.com<Cheerleading>Foam is a .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. </Cheerleading>Thanks for your time.Changed Foam.exe to Foam.zipEdited by - blastrix on 08/05/2002 12:54:00 |
|
|
Blastrix
Posting Yak Master
208 Posts |
Posted - 2002-08-05 : 11:51:19
|
| v1.1.0 of Foam has been released. I just wanted to say thank you to everyone has tried it so far. I haven't had one bad comment, in fact, most of them were full of thanks. Makes me feel good to know that this little application wasn't a wasted. Anyhow, yes, this is a new release of Foam, relatively close to the original release. There are absolutely no bug fixes! Why? Because nobody has found any bugs, hehe. It includes some added features that many people asked for, including the ability to create a "New" procedure, by giving you a clean slate, and some other little tweaks. You can of course download Foam from the link in the original post.Thanks everyone! |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-05 : 12:46:39
|
| Is it just me who gets "Page not found" clicking on the link ?HTHJasper Smith |
|
|
|
Blastrix
Posting Yak Master
208 Posts |
Posted - 2002-08-05 : 12:53:27
|
| Sorry about that Jasper, I packaged the application into a zip file with some other documents and didn't update the link. You can find it here:Foam.zip |
|
|
|
|
|
|
|
|
An Easy Way to Generate FOR XML EXPLICIT!