Xml data type

sql server India
  • 13 years ago

    Hi Friends,

                        In sql server 2005,on my table iam having XML datatype as Xmlfile,
    on that xmlfile ,some xml files having some values.
    some xml files having not.How to write the select query for retreiving the xml files having values?Its possible to get those values?Can any one help plz....

    Regards

    Divakar

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil perpetrated by skilled but perverted professionals.” - Jon Ribbens