你是一个书店的数据库开发者.你正设计一个存储程序来处理XML文档.你使用下面的脚本来
14 查阅
SELECT *FROM OPENXML (@docHandle, ‘/ROOT/category/Product’, 1)WITH (ProductID int,CategoryID int,CategoryName varchar(50),[Description] varchar (50))
SELECT *FROM OPENXML (@docHandle, ‘/ROOT/category/Product’, 8)WITH (ProductID int,CategoryID int,CategoryName varchar(50),[Description] varchar (50))
SELECT *FROM OPENXML (@docHandle, ‘/ROOT/category/Product’, 1)WITH (ProductID int,CategoryID int,CategoryName varchar(50), ‘@CategoryName’,[Description] varchar (50))
SELECT *FROM OPENXML (@docHandle, ‘/ROOT/category/Product’, 1)WITH (ProductID int,CategoryID int ‘../@CategoryID’,CategoryName varchar(50), ‘../@CategoryName’,[Description] varchar (50))
参考答案: