Category: SQL Server
view more software Tips and Tricks
Updated: 07/29/2016 07:07 AM
Author: Shiju Mathews
It specifies how SQL Server treats the data that is defined in Single Quotes and Double Quotes. When it is set to ON any character set that is defined in the double quotes “” is treated as a T-SQL Identifier (Table Name, Proc Name, Column Name….etc) and the T-SQL rules for naming identifiers will not be applicable to it. And any character set that is defined in the Single Quotes ‘’ is treated as a literal.
References : https://msdn.microsoft.com/en-us/library/ms174393.aspx