It specifies how SQL Server treats the data that is defined in Single Quotes and Double Quotes.
When it is set to ON
In above example as tbl_Name and col_Name are treated as identifier and the t-sql rules for identifier names are ignored.
When it is set to OFF
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)
- The T-SQL rules for naming identifiers will not be applicable to it
- Any character set that is defined in the Single Quotes ‘’ is treated as a literal.
In above example as tbl_Name and col_Name are treated as identifier and the t-sql rules for identifier names are ignored.
When it is set to OFF
- any character set that is defined either in Single Quotes or in Double Quotes is treated as a literal.
No comments:
Post a Comment