Listing 1: T-SQL Code That Uses the XML Data Type Methods
DECLARE @myDoc xml
DECLARE @myResult xml

SET @myDoc = '<IndividualSurvey>
  <DateOfFirstPurchase>2001-07-22T00:00:00</DateOfFirstPurchase>
  <MaritalStatus>M</MaritalStatus>
  <Gender>M</Gender>
  <NoOfChildren>2</NoOfChildren>
  <NoOfChildrenAtHome>0</NoOfChildrenAtHome>
  <HomeOwnerFlag>1</HomeOwnerFlag>
  <NoOfCarsOwned>0</NoOfCarsOwned>
  <Hobby>Golf</Hobby>
  <Hobby>Watch TV</Hobby>
</IndividualSurvey>'

SELECT @myDoc::query('/IndividualSurvey[Gender="M"]/NoOfCarsOwned')
SELECT @myDoc::value('/IndividualSurvey[Gender="M"]/NoOfCarsOwned','int')
SELECT @myDoc::exist('/IndividualSurvey[Gender="M"]/NoOfCarsOwned')