I want to update and delete xml file using stored procedure in sql server

See more:

XML

SQL-Server

stored-procedure

0 down vote favorite


I want these things should happen in my stored procedure,

If XML file has records, Delete all existing records for the PlantAreaID, Read and insert records from XML,And even i want to know how to create an XML file in SQL for this table

If successful Call sp_LogActivity ("Plant Area contacts updated successfuly-)

My PlantAreaContacts Table is like this:

PlantAreaID int,
PlantAreaContact varchar(55),
IsAreaHead int,
AreaEmailID varchar(50),
AreaMobileNumber varchar(50),
LoginPassword varbinary(max),
SystemPermission varchar(25)