Sql query to Check if any of columns in a XML row has value

Question

I have below XML. I need to check if any of column in this row has a value or not.

<row>
    <Row></Row>
    <TaskName></TaskName>
    <TaskType>someFooValue</TaskType>
    <PlanDate></PlanDate>
    <ForecastDate></ForecastDate>
    <Status></Status>
    <AssignedTo></AssignedTo>
    <Predecessors></Predecessors>
    <SortOrder></SortOrder>
    <Duration></Duration>
    <PerComplete></PerComplete>
    <PlannedEndDate></PlannedEndDate>
    <ForecastEndDate></ForecastEndDate>
</row>

roman · Accepted Answer · 2013-12-03 10:02:56Z

2

select @data.exist('row/*[text()]')

Will return 1 if there're some non-empty value.

sql fiddle demo

answered Dec 3, 2013 at 10:02

roman

118k30 gold badges205 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql query to Check if any of columns in a XML row has value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related