Uday Suragani

Uday Suragani

  • NA
  • 79
  • 3.6k

Select Query for XML data in sqlserver.

Sep 21 2017 1:44 AM
column name is settings, table name is general settings i want to get the value from xml  data, IsStudentEnabled with where id condition.
  1. <Settings>  
  2.    <EnableAllUsers>0</EnableAllUsers>  
  3.    <FacialConfirmation>0</FacialConfirmation>  
  4.    <AllowRandomization>0</AllowRandomization>  
  5.    <IsStudentMenuEnabled>1</IsStudentMenuEnabled>  
  6.    <Description>0</Description>  
  7. </Settings>  
 

Answers (1)