CODEWITHSUNDEEP
sqlsql-serverxmlxpathsqlxml
Mayank Pathak
Mayank Pathak

Reputation: 3681

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

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>

Upvotes: 1

Views: 170

Answers (1)

roman
roman

Reputation: 117380

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

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

sql fiddle demo

Upvotes: 2

Related Questions