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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-23 : 00:27:13
|
| Ryan Counts writes "Greetings,This may not be the best place to ask this question, but I'm running out of places to look. I'm developing an extranet solution for my company, and have been looking at SQL 2000 Server's XML capabilities as a way of distributing process load for the applications being used. Now, MSDN and 4guysfromrolla both have excellent articles on how to retrieve SQL recordsets via XML. However, no one seems to have much information on SQL's capabilities for updating via XML. Mostly, all I've found is propaganda for how wonderful it is, and the SQL Server Books Online has an article entitled "Sample Visual Basic Application to Update Records Using OPENXML and ADO", which is very vague and has no reference listing for the possibilities. So, I suppose this is a two part question for you. 1) Is there any reference for the capabilities of the OPENXML update capabilities of SQL 2000, and possibly code samples or something.2) Has anyone analyzed the performance of this feature? Would it really improve performance over standard methods of updating SQL, such as ADO, etc.? Or is this just another neat toy that everyone will be laughing about in years to come?Thanks,Ryan" |
|
|
|
|
|
|
|
Update Grams