What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?

Add comment

Votes: 0

Comments: 0

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers.

Others in this Category

	What is PRIMARY KEY?
	What is DataWarehousing?
	What is use of DBCC Commands?
	What is UNIQUE KEY constraint?
	What is SQLCMD?
	Which TCP/IP port does SQL Server run on? How can it be changed?
	Q: What is an execution plan? When would you use it? How would you view the execution plan?
	Q: What is normalization?
	What are the advantages of using Stored Procedures?
	What is Difference between Function and Stored Procedure?
	» More articles