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 / 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


Please Help Members By Posting Answers For Below Questions

What are the different types of collation sensitivity in sql server?

1113


How to create dbo table in sql server?

954


Explain go command in sql server?

1040


What is a transaction and why is it important?

1091


How to loop through the result set with @@fetch_status?

1349


How does Report Builder support Analysis Services cubes?

153


What are the types of containers in ssis?

1171


How to count rows with the count(*) function in ms sql server?

1017


How do you clear a log file?

1048


what are the reporting service components in SSRS?

163


What is the difference between osql and query analyzer?

997


Can I disable or restrict ssrs export formats (rendering formats)?

150


what is the different types of backups available in sql server? : Sql server database administration

931


How to create a user to access a database in ms sql server using "create user" statements?

954


Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145