Using XML with Stored Procedures Effectively in SQL Server 2005 @ .NET DEVELOPER'S JOURNAL

Using XML with Stored Procedures Effectively in SQL Server 2005

.NET lets us easily serialize an object into XML and deserialize XML into its corresponding object. This functionality has been available since .NET 1.0. The introduction of new data type called XML in SQL Server 2005 gives us even more advantages that come in handy with Stored Procedures that attempt to insert/update records in multiple but related tables.

Reader Feedback : Page 1 of 1

#4	Steve Jones commented on the 1 Apr 2008 Works great until you want to serialize a class that inherits from another class. That's when starts to breaks down.
#3	Amy Pham commented on the 20 Feb 2008 Can you also provide an example of updating using XML? Thanks, Amy
#2	Amy Pham commented on the 7 Feb 2008 Thanks so much for this example. It's so easy to follow and it works. The only thing that I would like to change is to replace @@Identity with SCOPE_IDENTITY(). Contributors like you make life a lot easier :-)
#1	munkeecoder commented on the 13 Sep 2007 Great idea! Good article, thanks for taking the time to share with us. Are there performance issues using an XML parser to do this instead of the old trusty parameter way? We still are looking for the best performance despite advances in memory and disk access.

YOUR FEEDBACK

	ASP.NET By Adam Calderon DavidL wrote: Thanks for the demo it has been very helpful understanding state machine workflows. But a question, when I run the demo, I can never find data being restored from the workflow after it has been passed into the workflow. Specifically this line in default.aspx.cs: (...
	Do Not Buy Your BlackBerry From AT&T By Engin Sezici oilsandy wrote: How much did you pay for the extra support from AT&T? Why do you assume retailers know more than you? It sounds like they went above the call of duty to get you up and running when you could have easily done it yourself. They gave you a free device, they hauled ...
	Working at Google vs. Working at Microsoft By Dare Obasanjo Ray the Barbarian wrote: I worked at Microsoft Research, and I had an in person interview with Google last year. It took three weeks after the interview to get a thumbs down. It took 4 weeks of phone interviews, email exchanges, and puzzles to work on at home before getting...
	Iterators in C#: Nothing Beats the Foreach Loop By Jason Whittington dave wrote: screw your crappy pop ups that wont mimimize
	Wind River to Enable Virtualization for Devices with Introduction of Scalable Hypervisor By Virtualization News Desk Virtualization news for the channel community and you ! wrote: Trackback Added: Wind River to Enable Virtualization for Devices with Introduction of Scalable Hypervisor; Wind River introduced a comprehensive multicore software solution for device development. Wind River&...