I have already sent the procedure in my previous post.
Sorry, I was updating my post. I will try.
But why you have used <xml><table> etc. I am not storing the whole xml table. I have a table containg only 3 fields. Id, Name, Value. Where Id is for identifying every setting differentely. Name is the name of setting e.g. SiteName, AreCommentsAllowed, NoOfPosts
etc. and Value is the actual value of the setting which defines it. e.g.SiteName = abcd.com, AreCommentsAllowed = No, NoOfPosts = 7 etc....
sophia_asp
Member
521 Points
470 Posts
Re: Update multiple rows at once
Feb 20, 2012 07:15 AM|LINK
Sorry, I was updating my post. I will try.
But why you have used <xml><table> etc. I am not storing the whole xml table. I have a table containg only 3 fields. Id, Name, Value. Where Id is for identifying every setting differentely. Name is the name of setting e.g. SiteName, AreCommentsAllowed, NoOfPosts etc. and Value is the actual value of the setting which defines it. e.g.SiteName = abcd.com, AreCommentsAllowed = No, NoOfPosts = 7 etc....
Thanks....