---
title: "What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?"  
description: "What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?"  
author: "Anonymous User"  
published: 2011-05-11  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/880/what-does-it-mean-to-have-quoted_identifier-on-what-are-the-implications-of-having-it-off  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

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

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.

## Answers

### Answer by Anonymous User

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.


---

Original Source: https://www.mindstick.com/interview/880/what-does-it-mean-to-have-quoted_identifier-on-what-are-the-implications-of-having-it-off

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.