Subscribe To

Subscribe to SQL Server and XML by Email

Friday, April 27, 2007

Sales Order Workshop - Articles at

I wrote a few articles at recently. It was a series of 4 articles which presents an XML based solution to the classical problem of saving a header/detail data entry form by hitting the databse server only once. The first article presented the basics of the approach and each installment there-after discussed more and more advanced stuff.


The discussion started with using an XML buffer to pass the variable number of item details to the Stored procedure. Then we discussed using XML nodes as well as attributes. The last article introduced the XML data type of SQL Server 2005 and a few XML processing functions.


You can find the articles here:

Part I - Introducing the approach using XML buffer

Part II - Introduces XML attributes

Part III - Little more advanced XML processing

Part IV - Introduces XML data type of SQL Server 2005


Hope this helps


Post a Comment

About Me
Jacob Sebastian
* XQuery Tutorials
My Links
SQL Server White Papers
SQL Server 2008
My Articles
XML Workshop RSS Feed
Contact me
Free Hit Counter
Web Site Hit Counters
SQL Server Bloggers
Blog Directories
blogarama - the blog directory Programming Blogs - BlogCatalog Blog Directory
Copyright Jacob Sebastian