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

You work at the r


You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the customers in your region. The database administrator in the main office asks that the data be sorted by the StateProvince,Surname, and FirstName columns.You need to satisfy these requirements by using the least amount of effort. What should you do?()

  • ASpecify StateProvince, Surname, and FirstName in the ORDER hint in the bcp out command.
  • BCreate a format file for the export operation.
  • CSpecify StateProvince, Surname, and FirstName in the ORDER BY clause in the bcp queryout command.
  • DCopy the data into a new table that has a clustered index on StateProvince,Surname,and FirstName. Export the data.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、You work as the e

You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use ofMicrosoft&ens...

2、You work as the e

You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use ofMicrosoft&ens...

3、You work as the I

You work as the IT professional in an international company which is named Wiikigo. You ar...

4、You work as the I

You work as the IT professional in an international company which is named Wiikigo. You ar...

5、You work as the e

You work as the enterprise exchange administrator at Company.com.The Company.com network consists of&ensp...

6、You work as the I

You work as the IT professional in an international company which is named Wiikigo. You ar...