Jump to content

Search the Community

Showing results for tags 'xml sql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Calendars

  • Community Calendar

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. Please help! I am new to implementing xml within SQL. I'm trying to create a stored procedure that creates an xml node when a user enters data within my website. Below is a sample of my stored procedure. I have tried to declare the namespace within the insert however I continue to receive the "undeclared prefix" error message. Code: DECLARE @Term XML = '<wma:Term>My First Term</wma:Term>'DECLARE @x XML SELECT @x = MetaDataFROM [Products] WHERE ID = 1SET @x.modify ('declare namespace wma="http://www.google.com/wma"; insert sql:variable("@Term") as last into (/wma:WMA/wma:List)[1] Expected results: <wma:WMA xmlns:wma="http://www.google.com/wma"> <wma:List> <wma:Term>My First Term</wma:Term> </wma:List></wma:WMA>
×
×
  • Create New...