Select Query for XML data in sqlserver.

Question

column name is settings table name is general settings i want to get the value from xml data IsStudentEnabled with where id condition. Settings > EnableAllUsers > 0 EnableAllUsers > FacialConfirmation > 0 FacialConfirmation > AllowRandomization > 0 AllowRandomization > IsStudentMenuEnabled > 1 IsStudentMenuEnabled > Description > 0 Description > Settings >

Ankit Sharma · Answer

Hi Uday Use this code .This will give you all the tags in xml as table column. then you can use them as u want. DECLARE @inxml as XML SET @inxml=' 0 0 0 1 0 ' SELECT EnableAllUsers=x.v.value( 'EnableAllUsers[1]'  'INTEGER' ) FacialConfirmation =x.v.value( 'FacialConfirmation[1]'  'INTEGER' ) AllowRandomization =x.v.value( 'AllowRandomization[1]'  'INTEGER' ) IsStudentMenuEnabled =x.v.value( 'IsStudentMenuEnabled[1]'  'INTEGER' ) [Description] =x.v.value( 'Description[1]'  'INTEGER' ) FROM @inxml.nodes( 'Settings' ) as x(v) Try this and let me know if this works