Interested to Buy Any Domain ? << Click Here >> for more details...
What does it mean to have quoted_identifier on? What are the
implications of having it off?
- 2 Answers
- 10897 Views
- I also Faced
- E-Mail Answers
Answer Posted / koti-khammam
when QUOTED_IDENTIFIER option is specified as ON ,the
identifiers are placed with in double quotation and
constants are placed with in single quotation.
when QUOTED_IDENTIFIER is OFF,the identifiers are not placed
with in double quotation and we must follow all T-SQL rules
for the identifiers.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What action plan is preferred if sql server is not responding?
What is history table in sql server?
What is self contained multi valued query?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What happens if time-only values are provided as date and time literals?
Relational calculus is what type of language?
What is the difference between functions and scalar functions?
How check triggers in sql server?
What is after dml trigger?
What do you understand by replication in sql server?
What is usually the first word in a sql query?
How to find out the list schema name and table name for the database?
How to view existing indexes on an given table using sp_help?
What are Spatial data types in SQL Server 2008
Can binary strings be converted into numeric or float data types?
