Create Proc USP_INSERTXMLTOTABLE @Xmldoc NTextas
Set nocount ondeclare @HDoc int
Beginexec sp_xml_preparedocument @HDoc output, @ xmldoc
- Update TB_SYS_CLAN Table INSERT INTO TB_SYS_CLANSELECT * from OpenXML (@HDOC, '/Tables/table/row [@tablename="tb_sys_clan"]' ,1) with (id int "./ID/text () ' Clanname varchar (50) './clanname/text ()')
EXEC SP_XML_REMOVEDOCUMENT @HDOC EndGo
