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 is bcnf normalization form?

1158


What are functions in the sql server?

1292


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2821


how to take backup bcp out for a column in table in sql server?

2142


How to use values from other tables in update statements in ms sql server?

1181


How to use the inserted and deleted pseudo tables?

1001


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1003


What is the use of for clause?

1162


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1048


How to convert character strings into numeric values?

1144


What is a filestream?

1045


how you can list all the tables in a database?

1067


What is the report builder?

143


What are points to remember while using the fillfactor argument?

1016


How to select all columns of all rows from a table with a select statement in ms sql server?

1190