Re: How can I replace a value in xml with .modify from the variable?

Hello Farmer,

Off the top of my head, sp_sqlexcutesql is the only was to do this as the constructor isn't availble in XQuery DML for SQL Server 2005.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/


.

Relevant Pages

  • Re: Passing XML between 2005 and 2000
    ... SQL Server MVP - http://sqlblog.com ... "Expert SQL Server 2005 Development" ... "Kent Tegels" wrote in message ...
    (microsoft.public.sqlserver.xml)
  • Re: Developing with SQL Server 2005 Beta 2/3
    ... "Kent Tegels (MVP)" wrote: ... >> upgrade the database to the commercial version when it releases in the summer ... > MVP - SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: Help: exporting bulk data from field
    ... I could export some data from field to a file width query: ... Which version of SQL Server? ... Kent Tegels, DevelopMentor ...
    (microsoft.public.sqlserver.xml)
  • Re: Passing XML between 2005 and 2000
    ... The XML is being passed to a SQL Server 2000 instance. ... "Kent Tegels" wrote in message ... Nice trick, ...
    (microsoft.public.sqlserver.xml)
  • SQL Server 2005 Book
    ... I know this is not SQL Server 2005 group but still I hope ... Is there any good book out there for Beginners of SQL ... The only book I could find out is this (on Amazon): ... Or some other good bookavailble? ...
    (microsoft.public.sqlserver.programming)
Loading