• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

SET QUOTED IDENTIFIER

Hi,
  What is the difference between SET QUOTED IDENTIFIER ON and SET QUOTED IDENTIFIER OFF in simple words?

Thanks.
0
amitabh04
Asked:
amitabh04
1 Solution
 
QPRCommented:
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.

http://ranjithk.com/2010/01/10/understanding-set-quoted_identifier-onoff/
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now