1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

Question Posted / mukund hans


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql db..

Answer / Saurav Kumar Singh

The 'quoted_identifier' setting in SQL Server determines whether identifiers (like table names, column names, and stored procedure names) can be enclosed within double quotes. When 'quoted_identifier' is ON, you can use double quotes to refer to identifiers that contain special characters or keywords without the need for escaping. If it's OFF, identifiers must not contain spaces or special characters unless they are properly escaped.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are sql injection vulnerabilities?

1 Answers  

Can we use delete in merge statement?

1 Answers  

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1 Answers  

In a distributed database system, can we execute two queries simultaneously?

1 Answers  

How do I make sql search faster?

1 Answers  

Is there any restriction on the use of union in embedded sql?

1 Answers  

What is a field in a database?

1 Answers  

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

What is the best partition size for windows 10?

1 Answers  

explain primary keys and auto increment fields in mysql : sql dba

1 Answers  

What is coalesce sql?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories