What Does It Mean To Have Quoted_identifier On? What Are The Implicat

1.	What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
Answer» SET QUOTED_IDENTIFIER ON- CAUSES SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal STRINGS. Identifiers delimited by double quotation MARKS can be either Transact-SQL RESERVED keywords or can contain characters not usually allowed by the Transact-SQL syntax rules for identifiers. SET QUOTED_IDENTIFIER ON- Causes SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not usually allowed by the Transact-SQL syntax rules for identifiers.

What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?

Answer»

SET QUOTED_IDENTIFIER ON- CAUSES SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal STRINGS. Identifiers delimited by double quotation MARKS can be either Transact-SQL RESERVED keywords or can contain characters not usually allowed by the Transact-SQL syntax rules for identifiers.

SET QUOTED_IDENTIFIER ON- Causes SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not usually allowed by the Transact-SQL syntax rules for identifiers.

Discussion

No Comment Found

Related InterviewSolutions

What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
What Is Task?
How Does You Handle This Com Components Developed In Other Programming Languages In .net?
How Do U Call And Execute A Stored Procedure In .net?
How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
What Is The Stuff Function And How Does It Differ From The Replace Function?
Explain Differences Between Framework 1.0 And Framework 1.1?
What Are The Differences Between User Control And Web Control And Custom Control?
How Do Sql Server 2000 And Xml Linked? What Is Sql Server Agent?
If We Write Any Code For Datagrid Methods, What Is The Access Specifier Used For That Methods In The Code Behind File And Why And How? Give An Example?