You are creating an online catalog application tha...
单选题

You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do?()

发布日期:2020-04-10

A.Add an XML index to the table that contains the product data.

B.Add the XSINIL argument to the ELEMENTS directive in the query.

C.Add a HAVING clause to the query.

D.Add the replace value of clause to the query.

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定