xml的数据怎么导入mysql_请教下 怎么将xml中的数据导入到sql server数据库的一张表中...

正好我也在做刚自己写了一个demo 看下能报到你么 我也是网上搜的

ALTER PROCEDURE [dbo].[xmlToTableTest]

@xml varchar(max), --xml

@doc int

AS

BEGIN

SET NOCOUNT ON;

EXEC sp_xml_preparedocument @doc OUTPUT, @xml

SELECT

T.SoldToAccount,

T.SoldToAddressCity,

T.SoldToAddressCountry,

T.SoldToAddressPostalCode,

T.SoldToAddressState,

T.SoldToAddressStreet,

T.SoldToAddressStreet2,

T.SoldToAddressStreet3,

T.QuoteNumberwithRevision

FROM

OPENXML(@doc, '/QUOTE/QUOTEHEADER',2)

WITH

(

SoldToAccount VARCHAR(20),

SoldToAddressCity VARCHAR(20),

SoldToAddressCountry VARCHAR(20),

SoldToAddressPostalCode VARCHAR(20),

SoldToAddressState VARCHAR(20),

SoldToAddressStreet VARCHAR(20),

SoldToAddressStreet2 VARCHAR(20),

SoldToAddressStreet3 VARCHAR(20),

QuoteNumberwithRevision VARCHAR(20)

)AS T

END