Quotation Marks

SQL Server 6.0

By default, assumes a single or double quotation mark begins and ends a string. Once the SET QUOTED_IDENTIFIER ON option has been specified, assumes double quotation marks are used only as delimiters for identifiers; strings must be delimited by single quotation marks.

SQL Server 4.2x

By default, assumes a single or double quotation mark begins and ends a string.