Update XML field (Insert,Update,Delete)

select Xml field 
  SELECT id,Fields, Fields.value('(/FieldsDictionary/field[@name="ShowVersionWarning"]/boolean/text())[1]', 'varchar(50)') AS DontDisplayVersionWarningMessage
FROM [dbo].[ShopAccounts]


 update [dbo].[ShopAccounts]
 SET Fields.modify('insert <field name="ShowVersionWarning" type="System.Boolean, mscorlib">
    <boolean>true</boolean>  </field> into (/FieldsDictionary[1])')
 update [dbo].[ShopAccounts]
 SET Fields.modify('insert <field name="VersionWarningStartDate" type="System.DateTime, mscorlib">
    <dateTime>2018-07-02T12:31:18.8564092+05:30</dateTime>
  </field> into (/FieldsDictionary[1])')
 update [dbo].[ShopAccounts]
 SET Fields.modify('insert <field name="DontDisplayVersionWarningMessage" type="System.Boolean, mscorlib">
    <boolean>false</boolean>
  </field> into (/FieldsDictionary[1])')


Delete

UPDATE [dbo].[ShopAccounts] 
SET Fields.modify('delete /FieldsDictionary/field[@name="ShowVersionWarning"][1]')
UPDATE [dbo].[ShopAccounts] 
SET Fields.modify('delete /FieldsDictionary/field[@name="VersionWarningStartDate"][1]')

update exsisting data

UPDATE [dbo].[ShopAccounts] 
SET Fields.modify('replace value of (/FieldsDictionary/field[@name="ShowVersionWarning"]/boolean/text())[1] with "true"')
where email ='accounts@atmosphereair.net.au'
select where 
SELECT id,Fields, Fields.value('(/FieldsDictionary/field[@name="ShowVersionWarning"]/boolean/text())[1]', 'varchar(50)') AS DontDisplayVersionWarningMessage
FROM [dbo].[ShopAccounts]
where Fields.value('(/FieldsDictionary/field[@name="ShowVersionWarning"]/boolean/text())[1]', 'varchar(50)') <>''