1. Select Tools->Export Data from the Menubar. This will prompt the user to choose a server from which to export data. He/she may then navigate, select the server and click ok. This will bring up the Export dialog.

2. The first tab in the wizard is the General Tab. In this section the user must specify the source of the data to be exported. The first option is to specify a table to export which will export the contents of the table. The next choice is to specify a SELECT statement of which the results will be exported. If the he/she specifies a SELECT statement, then he/she must also select a database in the database combo box in which the statement will be executed.

3. In the Options Tab, the user may first begin by browsing and selecting a file location in which to save the exported data. The user may then specify the encoding and platform into which the file will be saved. One of two formats may be specified: delimited data or Insert statements. When the user specifies delimited data, he/she chooses the delimiter, quote identifier, NULL value and whether to include the column names as the first of the export. When he/she chooses the INSERT statement format, the user can execute later in the Query Analyzer.

4. Once in the Status Tab the export has begun. The user may cancel the export at any time by clicking on the cancel button at the bottom of the dialog. If any errors or warnings occur, they will be displayed in the message text window.

Date and time formats are specified by date and time pattern strings. Within date and time pattern strings, unquoted letters from ’A’ to ’Z’ and from ’a’ to ’z’ are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (’) to avoid interpretation. "’’" represents a single quote. All other characters are not interpreted; they are simply copied into the output string during formatting, or they are matched against the input string during parsing.

Letter	Date or Time Component	Presentation	Examples
`G`	Era designator	Text	`AD`
`y`	Year	Year	`1996`; `96`
`M`	Month in year	Month	`July`; `Jul`; `07`
`w`	Week in year	Number	`27`
`W`	Week in month	Number	`2`
`D`	Day in year	Number	`189`
`d`	Day in month	Number	`10`
`F`	Day of week in month	Number	`2`
`E`	Day in week	Text	`Tuesday`; `Tue`
`a`	Am/pm marker	Text	`PM`
`H`	Hour in day (0-23)	Number	`0`
`k`	Hour in day (1-24)	Number	`24`
`K`	Hour in am/pm (0-11)	Number	`0`
`h`	Hour in am/pm (1-12)	Number	`12`
`m`	Minute in hour	Number	`30`
`s`	Second in minute	Number	`55`
`S`	Millisecond	Number	`978`
`z`	Time zone	General time zone	`Pacific Standard Time`; `PST`; `GMT-08:00`
`Z`	Time zone	RFC 822 time zone	`-0800`

The following examples show how date and time patterns are interpreted in the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone.

Date and Time Pattern	Result
`"yyyy.MM.dd G ’at’ HH:mm:ss z"`	`2001.07.04 AD at 12:08:56 PDT`
`"EEE, MMM d, ’’yy"`	`Wed, Jul 4, ’01`
`"h:mm a"`	`12:08 PM`
`"hh ’o’’clock’ a, zzzz"`	`12 o’clock PM, Pacific Daylight Time`
`"K:mm a, z"`	`0:08 PM, PDT`
`"yyyyy.MMMMM.dd GGG hh:mm aaa"`	`02001.July.04 AD 12:08 PM`
`"EEE, d MMM yyyy HH:mm:ss Z"`	`Wed, 4 Jul 2001 12:08:56 -0700`
`"yyMMddHHmmssZ"`	`010704120856-0700`

Export Tool Enhancement

The Export Tool now has an option to indicate the Date quote identifier for the output results.