You need to ensure that the following requirements are met: The first row of the file contains the first row of data

HOTSPOT
You administer a Microsoft SQL Server 2012 database. The database contains a table that
has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and
Export Wizard.
You need to ensure that the following requirements are met:
The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that
you would configure.)

HOTSPOT
You administer a Microsoft SQL Server 2012 database. The database contains a table that
has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and
Export Wizard.
You need to ensure that the following requirements are met:
The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, simply select the option or options in the answer area that
you would configure.)

Answer:

Explanation:

http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx



Leave a Reply 3

Your email address will not be published. Required fields are marked *


ToZorMan

ToZorMan

Without “Column names in the first data row”

Henk

Henk

Agree

“You need to ensure that the following requirements are met:
The first row of the file contains the first row of DATA.”

AlexanderS

AlexanderS

462 question