When I update portions of an XML document in SS05, am I forced to update the entire document. The XQuery standard seems to imply this, so I'm wondering if the good folks at MS have offered us perhaps their own way to avoid doing a full document refresh on a single change. Help
updating XML in SS05
Hot Topic
- Problem connecting to database
- Using a Parameter for ORDER BY Clause
- Using Transactions causes database connection to fail
- Connect MS SQL Server to UniData tables
- cannot connect to a remote database
- Relationship diagrams in SQL mobile 2k5
- Error: Unable to load one or more of the requested types.
- Cannot connect to SQL Server
- Shared Datasources that use dynamic DB connection strings
- [Expired subscription clean up] job failing
SQL Server
- Dynamic building of reports in C# for ASP.NET
- Simple Query Help
- Insert Into statement syntax error
- MSDE 2000 Timeout when restoring a database
- Suspect Mode (no icon in SQL 2005)
- ahh fer the luvva...
- Package hangs on parallel "upserts"
- Multiple MDF in SQL Express?
- Possible to use Calendar control with date parameter?
- How can I configure sql mail in sql express?
updating XML in SS05
Scooter26
You may want to look at the XML-DML language and the modify() method on the XML datatype.
Best regards
Michael