RFC 4180 defines Common Format and MIME Type for Comma-Separated Values (CSV) Files. One of the requirements of the RFC 4180 is stated below. SQL Server 2012 Import and Export wizard does not conform to the below stated requirement when exporting data to CSV file. Attached PDF file contains detailed steps to simulate and compare the output between SQL Server 2000 and SQL Server 2012.
RFC 4180 states the following:
If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote. For example: