Is there any function to check the named tag is exist or not?Date: Fri, 06 Jul 2007 13:30:40 +0200
References: <OedTiS4vHHA.3508@.TK2MSFTNGP03.phx.gbl>
Lines: 1
Reply-To: Martin.Honnen@.gmx.de
Organization: Liberty Development
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Geck
o/20060910 SeaMonkey/1.0.5
MIME-Version: 1.0
In-Reply-To: <OedTiS4vHHA.3508@.TK2MSFTNGP03.phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: i577ADC0F.versanet.de 87.122.220.15
Xref: leafnode.mcse.ms microsoft.public.sqlserver.xml:2208
ABC wrote:
> Is there any function to check the named tag is exist or not?
Like this, using the method 'exist' of the xml data type:
DECLARE @.x xml;
SET @.x = '<root><foo></foo></root>';
SELECT @.x.exist('//bar') AS barTest, @.x.exist('//foo') AS fooTest;
If that is not what you are looking for then explain in more detail what
you want to achieve.
Martin Honnen -- MVP XML
http://JavaScript.FAQTs.com/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment