XML file into SQL database

Xml

<?xml version="1.0"encoding="Utf-8"?><!--H5 channelsource--><items> <item key="55558962"Value="Client/android/mumayi"version="509.000"Url="http://download.ctrip.com/client/app/ctrip_590_8962.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> <item key="55558963"Value="Client/android/amazon"version="509.000"Url="http://download.ctrip.com/client/app/ctrip_590_8963.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> <item key="55558964"Value="client/android/jifeng1"version="509.000"Url="http://download.ctrip.com/client/android/ctrip_std_590.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> <item key="55558965"Value="client/android/jifeng2"version="509.000"Url="http://download.ctrip.com/client/app/ctrip_590_8965.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> <item key="55558966"Value="Client/android/jifeng3"version="509.000"Url="http://download.ctrip.com/client/app/ctrip_590_8966.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> <item key="55558967"Value="Client/android/jifeng4"version="509.000"Url="http://download.ctrip.com/client/app/ctrip_590_8967.apk"remark="found a new version of v5.9& #x000A; 1. Global Purchase: Shopping rebate as high as 10%, overseas goods without pressure & #x000A; 2. Gourmet Food: Food raiders also return to the present, Just eat it& #x000A; 3. Travel insurance: Sell on the insurance line to make your journey hassle-free & #x000A; 4. Local guide: Free line new weapon, Guide car trip planning & #x000A; 5. Overseas drive: Enjoy driving pleasure & #x000A; 6. Free line: Multiple destinations at the same time, free travel without fetters & #x000A; 7. International train ticket: Support multi-country pass booking, travel Europe without pressure"platform="Android"/> </items>

  DECLARE @h int -- define XML handle declare @doc XML -- Define XML Object Select @doc  = Bulkcolumn from OPENROWSET (BULK  '  , 2  ) EXECUTE sp_xml_removedocument @h --delete XML handle 

http://blog.csdn.net/royalwzy/article/details/6298675

XML file into SQL database