Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / bobby

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. For more
information, see Identifiers. Literals can be delimited by
either single or double quotation marks.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between connected and disconnected database in .net with sql server?

1079


What is data source document?

1016


What is the fastest way to permanently delete a 1 million row table named customers?

1237


How do you delete duplicate records in sql server?

1035


What is table level trigger?

997


What is the use of group by clause?

932


what are the critical issues you have resloved in your company

1952


How to create an multi-statement table-valued function?

977


Is null vs coalesce?

851


How ssrs maintain security?

1061


You want to implement the one-to-many relationship while designing tables. How would you do it?

942


What are the approximate numeric data types?

912


What are the differences between having and where clause.

958


Write a SQL query to delete a table?

1124


what is a mixed extent? : Sql server administration

1080