Post reply

querying xml data

  • October 11, 2006 at 11:58 am

    #174858

    Is there a way to find out which table in a database has xml data type columns? and also is it possible to search these fields for a string?

    thanks

  • October 11, 2006 at 1:01 pm

    #665289

    select

    tbl=t.name,

    col=c.name

    from sys.tables t join sys.columns c

    on t.object_id = c.object_id

    join sys.types p on c.System_type_id = p.System_type_id

    where p.name ='xml'

  • October 11, 2006 at 1:40 pm

    #665296

    is there any way to search for text/ value within xml field?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply