可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You are creating an&en


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?()

  • AAdd an XML index to the table that contains the product data.
  • BAdd the XSINIL argument to the ELEMENTS directive in the query.
  • CAdd a HAVING clause to the query.
  • DAdd the replace value of clause to the query.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、You are creating an&en

You are creating an error page that provides a user-friendly screen whenever a server exception...

2、You are creating a&ens

You are creating a Windows Forms application for inventory management by using the .NET Framewo...

3、You are creating a&ens

You are creating a locally managed tablespace to meet the following requirements: All the exte...

4、You are creating a&ens

You are creating a Windows Forms application by using the .NET Framework 3.5. You have imp...

5、You are creating a&ens

You are creating a new security policy for an application domain. You write the following ...

6、You are creating a&ens

You are creating a SQL Server 2005 database for a mortgage company. The database will supp...