InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:59:07 GMT20http://www.sqlservercentral.com/Forums/Topic1391846-392-1.aspxHave a look here[url]http://msdn.microsoft.com/en-us/library/ms345122(v=sql.90).aspx[/url]Mon, 03 Dec 2012 06:10:29 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic1391846-392-1.aspxthanks for you assistance i am just learning now how to use xml in sqlserver please assist me, can give some link to see like this kind of stuffMon, 03 Dec 2012 05:53:15 GMTthavahttp://www.sqlservercentral.com/Forums/Topic1391846-392-1.aspxYou need a namespace declaration[code="sql"]SET @AppName = @myDoc.value('declare default element namespace "urn:schemas-microsoft-com:asm.v1"; (/assembly/assemblyidentity/@Appname)[1]', 'char(150)' )SELECT @AppName[/code]Mon, 03 Dec 2012 05:30:49 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic1391846-392-1.aspx[code]DECLARE @myDoc xmlDECLARE @AppName VARCHAR(100)SET @myDoc = '<assembly xmlns="urn:schemas-microsoft-com:asm.v1"> <assemblyidentity version="2.2.2.2" Appname="Application2.app"> </assemblyidentity></assembly>' SET @AppName = @myDoc.value('(/assembly/assemblyidentity/@Appname)[1]', 'char(150)' )SELECT @AppName[/code]may i know what is wrong in this xmlMon, 03 Dec 2012 04:31:47 GMTthava