llewis 0 Posted October 14, 2015 Report Share Posted October 14, 2015 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> Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.