管理XML数据(5)

seasonings

Confections

Desserts, candies, and sweet breads

Dairy Products Cheeses ' DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT,@doc SELECT * FROM

OPENXML(@idoc,'/Categories/CategoryInfo',2) WITH (

CategoryID int '@CategoryID',

CategoryName VARCHAR(100) 'CategoryName', [Description] VARCHAR(100) 'Description' )